表格中的数据自动生成 html,[小记]使用JS将html中table表格数据导出到Excel文档

记录一下

/**

* 描述：导出表格对应到excel文件

* 调用示例：

* onclick = "tableToExcel(tableId,fileName)"

*/

var tableToExcel = (function() {

var uri = 'data:application/vnd.ms-excel;base64,'

, template = '

'+

'

'.excelTable {'+

'border-collapse:collapse;'+

' border:thin solid #999; '+

'}'+

' .excelTable th {'+

' border: thin solid #999;'+

' padding:20px;'+

' text-align: center;'+

' border-top: thin solid #999;'+

' '+

' }'+

' .excelTable td{'+

' border:thin solid #999;'+

' padding:2px 5px;'+

' text-align: center;'+

' }'+'

'

, base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }

, format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }

return function(table, name) {

if (!table.nodeType) table = document.getElementById(table)

var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML};

var downloadLink = document.createElement("a");

downloadLink.href = uri + base64(format(template, ctx));

downloadLink.download = name+".xls";

document.body.appendChild(downloadLink);

downloadLink.click();

document.body.removeChild(downloadLink);

}

})();