纯html导出excel合并单元格,js导出带格式的表格(包括单元格合并，字体样式等)...

function HtmlExportToExcelForEntire() {

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

template =

'

',

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 (name, userList) => {

var tableTest = document.createElement('table');

tableTest.innerHTML = this.assemblyData(userList);

var ctx = {

worksheet: name || 'Worksheet',

table: tableTest.innerHTML

}

var alink = document.createElement('a');

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

alink.download = name + ".xls";

alink.style.display = 'none';

document.body.appendChild(alink);

alink.click();

alink.parentNode.removeChild(alink);

}

}

function assemblyData(data) {

var tHeader = `

编号负责人`;

var tBody = '';

for (var item of data) {

tBody += '

'

tBody +=

`

${item.iid}${item.assignee.name}

`;

tBody += '

'

}

var htmlData = tHeader + tBody;

return htmlData;

}

调用方式：

HtmlExportToExcelForEntire()('导出的表格名称'，data);