JavaScript È°¿ëÆÁ
2016.11.29 / 24:39
Javascript, Excel Export
±â¸®¾Æºü
Ãßõ ¼ö 293
Excel Export ±â´ÉÀº ÀÚÁÖ´Â ¾Æ´ÏÁö¸¸ °£°£È÷ ÇÊ¿äÇÒ ¶§°¡ ÀÖ´Ù-
ÀÚÁÖ°¡ ¾Æ´Ï±â ¶§¹®¿¡ ¾µ ¶§¸¶´Ù °Ë»ö¿¡ ÀÇÁ¸ÇÏ°í..
Á¡Á¡ ½¬¿î ¹æ¹ýÀ» ã¾Æ°£´Ù-
ÀÌÀü¿¡ POI¸¦ ÀÌ¿ëÇÑ Excel °ü·Ã Æ÷½ºÆÃÀ» ÇÑ ±â¾ïÀÌ Àִµ¥- ÀÌ ¹æ¹ýÀÌ ÈξÀ Á÷°üÀûÀÌ°í ½¬¿î °Í °°´Ù-
¾Æ, ¹°·Ð ´ÜÁ¡ÀÌ Á¸ÀçÇÑ´Ù-
±ÛÀÚ Å©±â¶ó´ø°¡- ¹¹.. ¿©Æ° ÀÌ·±Àú·± ¼½ÄÀ» ÀüÇô ÀÌ¿ëÇÏÁö ¸øÇÑ´Ù-
(³»°¡ °Ë»öÀ» Àß ¸øÇؼ ±×·± °É ¼öµµ ÀÖ°í-)
°¢¼³ÇÏ°í-
ÄÚµå µé¾î°£´Ù-
<script type="text/javascript" src="/js/excel/xlsx.core.min.js"></script> <script type="text/javascript" src="/js/excel/Blob.js"></script> <script type="text/javascript" src="/js/excel/FileSaver.js"></script>
¿ä À§¿¡ ¼¼°³ÀÇ js ÆÄÀÏÀ» ³Ö°í- ¹Ø¿¡ ó·³..
var data = new Array(); var row = new Array(); row.push('val1'); row.push('val2'); row.push('val3'); data.push(row); var ws_name = 'Work Sheet1'; var wb = new Workbook(); var ws = sheet_from_array_of_arrays(data); wb.SheetNames.push(ws_name); wb.Sheets[ws_name] = ws; var wb_out = XLSX.write(wb, {bookType:'xlsx', bookSST:true, type:'binary'}); saveAs(new Blob([s2ab(wb_out)], {type:'application/octet-strean'}, 'File_Name.xlsx');
±²ÀåÈ÷ °£´ÜÇÏ´Ù-
¾Æ¸¶ Äڵ常 ºÁµµ ´Ù ÀÌÇØ°¡ µÉ µí-