JS 前端Table导出excel 支持多sheet页并且支持合并单元格
资源下载地址：https://download.csdn.net/download/qq_27946017/14890680
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>demo</title>
<script src="exportExcel.js" type="text/javascript" charset="utf-8"></script>
</head>
<body>
<table border="1" style="width: 400px;">
<thead>
<tr>
<th rowspan="2" colspan="2">标题</th>
<th colspan="2">汇总</th>
<th rowspan="2">日期</th>
</tr>
<tr>
<th>二级</th>
<th>三级</th>
</tr>
</thead>
<tbody>
<tr>
<td colspan="2">标题1</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题2</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题3</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题4</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题5</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
</tbody>
</table>
<table border="1" style="width: 400px;margin-top: 20px;">
<thead>
<tr>
<th rowspan="2">姓名</th>
<th colspan="2">成绩</th>
<th rowspan="2">日期</th>
</tr>
<tr>
<th>语文</th>
<th>数学</th>
</tr>
</thead>
<tbody>
<tr>
<td>张三</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>李四</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>王五</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>赵六</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>李琦</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
</tbody>
</table>
</body>
<script type="text/javascript">
console.log('exportToExcel', exportToExcel)
/*
//导合多sheet
var list1 = [{
ypsj: "2020-10-10",
tbbm: "技术科",
score: "99.12"
},
{
ypsj: "2020-10-11",
tbbm: "办公室",
score: "56.4"
},
];
var list2 = [{
ypsj: "2020-10-10",
tbbm: "技术科",
score: "73.567"
},
{
ypsj: "2020-10-11",
tbbm: "办公室",
score: "89"
},
];
const tHeader = [{
key: "ypsj",
name: "研判时间",
},
{
key: "tbbm",
name: "填报部门"
},
{
key: "score",
name: "代码",
format: "0.00", //单元格格式 例："0.00"代表数字保留2位小数，"@"代表文本，"Percent"代表百分比
style:{"text-align":"right"} //单元格样式
},
];
var excelInfo = {
name: "这是表格的名称",
sheets: [{
name: "这是sheet1",
content: list1,
tHeader: tHeader,
},
{
name: "这是sheet2",
content: list2,
tHeader: tHeader,
},
],
};
exportToExcel(excelInfo);
*/
//导合并单元格的
var content =
` <thead>
<tr>
<th rowspan="2" colspan="2">标题</th>
<th colspan="2">汇总</th>
<th rowspan="2">日期</th>
</tr>
<tr>
<th>二级</th>
<th>三级</th>
</tr>
</thead>
<tbody>
<tr>
<td colspan="2">标题1</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题2</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题3</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题4</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
<tr>
<td colspan="2">标题5</td>
<td>二级部门</td>
<td>三级部门</td>
<td>2020-01-09</td>
</tr>
</tbody>`
var content2 =
` <thead>
<tr>
<th rowspan="2">姓名</th>
<th colspan="2">成绩</th>
<th rowspan="2">日期</th>
</tr>
<tr>
<th>语文</th>
<th>数学</th>
</tr>
</thead>
<tbody>
<tr>
<td>张三</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>李四</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>王五</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>赵六</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
<tr>
<td>李琦</td>
<td>100</td>
<td>90</td>
<td>2020-01-09</td>
</tr>
</tbody>`
var excelInfo = {
name: "多sheet页复杂excel导出",
sheets: [{
name: "这是sheet1",
content: content,
}, {
name: "这是sheet2",
content: content2,
}],
};
exportToExcel(excelInfo);
</script>
</html>
