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 |