摘自文章:前端读取Excel报表文件 - 知乎
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<script src="xlsx/xlsx.full.min.js"></script>
</head>
<body>
<button onclick="exportAll()">导出(分多个sheet表, 并且能够合并列)</button>
</body>
<script>
let listData = [
{
deviceAmount: 2, deviceAmountEvery: 2, model: "MA9704E-B1", privilegeListArray: "ADAS", supplierName: "BBC", total: 22
},
{
deviceAmount: 3, deviceAmountEvery: 1, model: "MR98C-S4-B3", privilegeListArray: "ADAS,DSM", supplierName: "BBC", total: 22
},
{
deviceAmount: 3, deviceAmountEvery: 1, model: "MT95C-D4-B3", privilegeListArray: "ADAS,DSM", supplierName: "BBC", total: 22
},
{
deviceAmount: 3, deviceAmountEvery: 1, model: "MT95C-H4-B3", privilegeListArray: "ADAS,DSM", supplierName: "BBC", total: 22
},
{
deviceAmount: 6, deviceAmountEvery: 6, model: "MR98C-H6-B1", privilegeListArray: "ADAS,DSM,BSD", supplierName: "BBC", total: 22
},
{
deviceAmount: 1, deviceAmountEvery: 1, model: "MA9708E-B1", privilegeListArray: "ADAS,DSM,BSD,BSD2", supplierName: "BBC", total: 22
},
{
deviceAmount: 6, deviceAmountEvery: 4, model: "MR98E-H8-B1", privilegeListArray: "ADAS,DSM,DSM2,BSD,BSD2", supplierName: "BBC", total: 22
},
{
deviceAmount: 6, deviceAmountEvery: 2, model: "MR98E-H8-B1", privilegeListArray: "ADAS,DSM,DSM2,BSD,BSD2", supplierName: "BBC", total: 22
},
{
deviceAmount: 1, deviceAmountEvery: 1, model: "MR98C-H4-B1", privilegeListArray: "ADAS,DSM,DSM2,BSD,BSD2,CMS", supplierName: "BBC", total: 22
},
{
deviceAmount: 1, deviceAmountEvery: 1, model: "MA9504E-B1", privilegeListArray: "DSM,OMS", supplierName: "BBC", total: 22
},
{
deviceAmount: 2, deviceAmountEvery: 1, model: "MA9504E-B1", privilegeListArray: "DSM,BSD,OMS", supplierName: "BBC", total: 22
},
{
deviceAmount: 2, deviceAmountEvery: 1, model: "MA9504E-B1", privilegeListArray: "DSM,BSD,OMS", supplierName: "BBC", total: 22
}
],
listData2 = [
{
deviceAmount: 2,
deviceAmountEvery: 1,
endPrivilegeListArray: "ADAS,DSM",
model: "MR98E",
privilegeList: [1, 2],
privilegeListArr: "ADAS,DSM",
scrapDeviceAmount: 0,
supplierName: "魔视",
total: 8
},
{
deviceAmount: 2,
deviceAmountEvery: 1,
endPrivilegeListArray: "ADAS,DSM",
model: "MR98EH",
privilegeList: [1, 2],
privilegeListArr: "ADAS,DSM,BSD,BSD2",
scrapDeviceAmount: 0,
supplierName: "魔视",
total: 8
},
{
deviceAmount: 3,
deviceAmountEvery: 1,
endPrivilegeListArray: "ADAS,DSM,BSD",
model: "MR98EH",
privilegeList: [1, 2, 4],
privilegeListArr: "ADAS,DSM,BSD",
scrapDeviceAmount: 0,
supplierName: "魔视",
total: 8
},
{
deviceAmount: 3,
deviceAmountEvery: 1,
endPrivilegeListArray: "ADAS,DSM,BSD",
model: "MR98E",
privilegeList: [1, 2, 4],
privilegeListArr: "ADAS,DSM,BSD,BSD2",
scrapDeviceAmount: 0,
supplierName: "魔视",
total: 8
},
{
deviceAmount: 3,
deviceAmountEvery: 1,
endPrivilegeListArray: "ADAS,DSM,BSD",
model: "MR98E",
privilegeList: [1, 2, 4],
privilegeListArr: "ADAS,DSM,DSM2,BSD",
scrapDeviceAmount: 0,
supplierName: "魔视",
total: 8
},
{
deviceAmount: 2,
deviceAmountEvery: 1,
endPrivilegeListArray: "ADAS,DSM,DSM2",
model: "MR98EH",
privilegeList: [1, 2, 3],
privilegeListArr: "ADAS",
scrapDeviceAmount: 0,
supplierName: "魔视",
total: 8
},
{
deviceAmount: 2,
deviceAmountEvery: 1,
endPrivilegeListArray: "ADAS,DSM,DSM2",
model: "MR98EH",
privilegeList: [1, 2, 3],
privilegeListArr: "ADAS,DSM,BSD",
scrapDeviceAmount: 0,
supplierName: "魔视",
total: 8