HTML表格转Excel导出-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_36968082/article/details/86136159

此方法对table有效导出原理:专程html代码再使用类库进行excel生成

亲测对table有效别的没试!!!!!!!!

<table class="infoTable" id="tableInfo">

</table>

导出按钮

<a download="table导出Excel" id="excelOut" href="#" οnclick="c('tableInfo','导出信息')">导出信息</a>

方法代码

//sheetName:页码名称

function tableToExcel(tableid, sheetName) {

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

var template =

'<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel"' +

'xmlns="http://www.w3.org/TR/REC-html40"><head>' +

' <style type="text/css">' +

'table td {' +

'border: 1px solid #000000;' +

'width: 200px;' +

'height: 30px;' +

' text-align: center;' +

'background-color: #4f891e;' +

'color: #ffffff;' +

' }' +

'</style>' +

'</head><body ><table class="excelTable">{table}</table></body></html>';

tableid = document.getElementById(tableid);

var ctx = {

worksheet: sheetName || 'Worksheet',

table: tableid.innerHTML

};

document.getElementById("excelOut").href = uri + base64(format(template, ctx));

}

var base64 = function (s) {

return window.btoa(unescape(encodeURIComponent(s)));

};

//替换table数据和worksheet名字

var format = function (s, c) {

return s.replace(/{(\w+)}/g,

function (m, p) {

return c[p];

});

}