index.html
<html>
<head>
<meta charset="utf-8">
<title>Export to excel test</title>
<script src="js/excellentexport.js"></script>
<style>
table,
tr,
td {
border: 1px black solid;
}
</style>
</head>
<body>
<h3>Test page</h3>
<br/>
<a download="somedata.xls" href="#" onclick="return ExcellentExport.excel(this, 'datatable', 'Sheet Name Here');">Export to Excel</a>
<br/>
<a download="somedata.csv" href="#" onclick="return ExcellentExport.csv(this, 'datatable');">Export to CSV - UTF8 default is ","</a>
<br/>
<a download="somedata.csv" href="#" onclick="return ExcellentExport.csv(this, 'datatable', '@');">Export to CSV - Using semicolon "@" separator - UTF8</a>
<br/>
<table id="datatable">
<tr>
<th>Column 1</th>
<th>Column 2</th>
<th>Column 3</th>
<th>Column 4</th>
</tr>
<tr>
<td>100 111</td>
<td>200</td>
<td>300</td>
<td>test\ttest</td>
</tr>
<tr>
<td>400</td>
<td>500</td>
<td>Chinese chars: 解决导出csv中文乱码问题</td>
<td>test\r\ntest</td>
</tr>
<tr>
<td>Text</td>
<td>More text</td>
<td>Text with new line</td>
<td>test<br/>ttest<td>
</tr>
</table>
</body>
</html>
生成的格式为xls文件。如果想要生成后缀为xlsx的文件,将excellentExport.js中的表头信息修改一下即可。
github地址:https://github.com/jmaister/excellentexport