tabl2excel ¶óÀ̺귯¸® »ç¿ë
¡å ³»¿ë
table to excel converter
java ´ÜÀ̳ª jsp ´ÜÀ¸·Î poi³ª jxl ¶óÀ̺귯¸®¸¦ »ç¿ëÇÒ¼öÀÖÁö¸¸....
js ·Î ¹Ù²Ù°í½Í¾î ã¾Æº¸´Ù »ç¿ëÇϱâ ÆíÇÑ ¶óÀ̺귯¸®¸¦ ¹ß°ßÇÏ¿© °ü·ÃµÈ »ç¿ë¹ýÀ» ÀÛ¼ºÇÕ´Ï´Ù.
¾Æ·¡ ¼Ò½º¸¦ ´Ù¿î¹Þ¾Æ ¿¢¼¿·Î ½ÇÇàÇÏ¿³À»°æ¿ì À§ ±×¸²Ã³·³ export°¡ µÈ´Ù.
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<script type="text/javascript" src="../scripts/jquery-1.11.0.js"></script>
<script type="text/javascript" src="../scripts/jquery.table2excel.js"></script>
</head>
<body>
<table id="TableToExcel" border=2 width=710 cellpadding=0 cellspacing=0 class='table table-bordered' align=center style='border-collapse:collapse;' >
<thead>
<tr>
<td>¹øÈ£</td>
<td>¹øÈ£</td>
<td>¹øÈ£</td>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>1</td>
<td>1</td>
</tr>
<tr>
<td>2</td>
<td>2</td>
<td>2</td>
</tr>
<tr>
<td>3</td>
<td>3</td>
<td>3</td>
</tr>
</tbody>
</table>
<iframe id="txtArea1" style="display:none"></iframe>
<!-- IE ȣȯÀ» À§Çؼ iframeÀ» Ãß°¡ÇؾßÇÑ´Ù -->
<!-- IE¿¡¼´Â txtArea1 ÀÇ °´Ã¼¸¦ ã±â ¶§¹®ÀÌ´Ù. Å©·ÒÀº ¾ø¾îµµ µÈ´Ù. À־ »ó°üÀº ¾ø´Ù. -->
<input type='button' class='btn btn-inverse' value='excel ´Ù¿î' style='width:100px;height:36px;font-weight:bold;' onclick="ReportToExcelConverter()" />
</body>
<script>
function ReportToExcelConverter() {
$("#TableToExcel").table2excel({
exclude: ".noExl",
name: "Excel Document Name",
filename: "report" +'.xls',
fileext: ".xls",
exclude_img: true,
exclude_links: true,
exclude_inputs: true
});
};
</script>
</html>
À§ ¼Ò½ºÃ³·³ tableÀÇ id¸¦ ÁöÁ¤ÇÏ°í Á¦ÀÌÄõ¸®ÇÔ¼ö $("#¾ÆÀ̵ð") ¸¦ ÁöÁ¤ÇÑ´ÙÀ½ À§ ¼Ò½ºÃ³·³ ÀÛ¼ºÇϸé table À» ÀÚµ¿À¸·Î excel Çü½ÄÀ¸·Î export ÇØÁØ´Ù. script ¸¦ ºÒ·¯¿Ã¶§ ²À jquery ¸¦ ºÎ¸¥´ÙÀ½ table2excel.js ¸¦ ·ÎµåÇؾßÇÑ´Ù. ¶ÇÇÑ iframeÀ» ½áÁà¾ß ie¿¡¼ ÀÛµ¿À̵ȴÙ.
excel exprort.zip
¿¹Á¦ ÆÄÀÏÀÌ´Ù.
https://github.com/rainabba/jquery-table2excel
jquery-table2excel-master.zip
À§¿¡ ¸µÅ©°¡ °ø½Ä¹®¼°í ³ª´Â ¾Æ·¡¿¡¼ ´Ù¿î¹Þ¾Æ¼ ÀÛ¾÷ÇÏ¿³±â ¶§¹®¿¡ µÑ´Ù ¸µÅ©¸¦ ³²±ä´Ù
Ãâó: https://dydals5678.tistory.com/107 [¾Æºü°³¹ßÀÚÀÇ ³ëÆ®]