导出表格样式拼接
var tableCols = “”;
var tableColsx = “”;
var tableColsy = “”;
表头
tableCols = “”;
tableCols += “各小组完成情况”;
tableColsx += " " + ‘大组’ + “”
tableColsx += " " + ‘销售组’ + “”
tableColsx += " " + ‘人数’ + “”
tableColsx += " " + ‘月目标’ + “”
tableColsx += " " + ‘月业绩’ + “”
tableColsx += " " + ‘月完成率’ + “”
tableColsx += " " + ‘人均’ + “” // style=‘display:none’
tableCols = tableCols + “” + tableColsx + “”;
let y = ‘’
let nemlist = []
// 数据
exportData.forEach(item => {
let obj = {}
obj.cw = item.cw
obj.zu = item.zu
obj.hr_qty = item.hr_qty
obj.targe = item.targe
obj.wc_bili = item.wc_bili
obj.hr_jun = item.hr_jun
nemlist.push(obj)
})
for (let i = 0; i < nemlist.length; i++) {
//其余表头数据
let y = ‘’
for (let j in nemlist[i]) {
nemlist[i][j]
if (j != ‘LAY_TABLE_INDEX’) {
y += “” + nemlist[i][j] + “”;
}
}
tableCols = tableCols + y + "</tr>";
}
// 数据拼接
// tableCols = tableCols + "</tr><tr>" + tableColsx + tableColsy + "</tr>";
tableCols += "<tr>";
outdataao("小组完成情况", tableCols)
// 模块2导出方法
var outdataao = function (FileName, htmls) {
var excelFile = “”;
excelFile += ‘’;
excelFile += ‘’;
excelFile += “”;
excelFile += “
”;
excelFile += “”;
excelFile += “”;
excelFile += “
excelFile += “”;
excelFile += “”;
var uri = ‘data:application/vnd.ms-excel;charset=utf-8,’ + encodeURIComponent(excelFile);
var link = document.createElement(“a”);
link.href = uri;
link.style = “visibility:hidden”;
link.download = FileName + “.xls”;
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}