javascript table to Excel export 에 대한 포스팅입니다.
관련 URL : https://github.com/rainabba/jquery-table2excel/
html code :
1 |
<script src="/jquery/jquery.table2excel.js" type="text/javascript"></script> |
Mall Name | code | data type | 인입시간 | 파일 마지막 인입시간 | 파일수 | 색인시작시간 | 색인완료시간 | 소요시간 | 색인건수 |
---|
javascript :
1 2 3 4 5 6 7 |
$("#excel").click(function () { $("#schListTbl").table2excel({ name: "Worksheet Name", filename: filename, fileext: ".xls" }); }); |
1 |
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script><script src="../dist/jquery.table2excel.js"></script> |
This shouldn’t get exported | This shouldn’t get exported either |
This Should get exported as a header | This should too |
data1a with a link one and link two. | data1b with a ![]() |
data2a with a . | data2b with a . |
This footer spans 2 cells |
1 |
This shouldn’t get exported | This shouldn’t get exported either |
This Should get exported as a header | This should too |
data1a | data1b |
data2a | data2b |
This footer spans 2 cells |
1 |