在vue中，elementUI前端导出excel表，可以导出多级表头，
⼀级表头，⼆级表头，。。。
我项⽬⽤的vue-element-admin的模板，⾥⾯有导出的⽰例。不过只有⼀级和⼆级，
本项⽬只展现，导出三级表头⽰例，
可以参照我添加三级表头⽅式，进⾏，添加4,5,6等多级表头导出。
如下⽰例，先布局好，此处参照项⽬的⽰例即可，
methods: {
handleDownloadExcel() {
// this.downloadLoading = true
import("@/vendor/Export2Excel").then(excel => {
const multiHeader = [
[
"序号",
"旅⾏社",
"国内（温台意外）",
"",
"",
"",
"",
"",
"",
"（含港澳台）",
"",
"",
"",
"",
"",
""
]
];
const multiHeader2 = [
[
"",
"",
"门票消费⾦额",
"A类(张)",
"",
"B类(张)",
"",
"C类(张)",
"",
"门票消费⾦额",
"D类(张)",
"",
"E类(张)",
"",
const tHeader = [
"",
"",
"",
"全票",
"半价",
"全票",
"半价",
"全票",
"半价",
"",
"全票",
"半价",
"全票",
"半价",
"全票",
"半价"
]
;
// this.headVal是⼀个数组，表头所对应的字段，这⾥未填写，//⽐如：['id','age','name']，随便写的，以你的实际数据为准。
const filterVal = this.headVal;
let list = [];
if (this.tableDataExcelType == 0) {
list = this.tableDataExcel;
} else {
list = this.tableDataExcelAll;
}
const data = this.formatJson(filterVal, list);
//进⾏所有表头的单元格合并，建议⼀⾏⼀⾏来，不然容易整乱        const merges = [
"A1:A3",
"B1:B3",
"C1:I1",
"J1:P1",
"C2:C3",
"D2:E2",
"F2:G2",
"H2:I2",
"J2:J3",
"K2:L2",
"M2:N2",
"O2:P2"
];
//  const merges = ['A1:A2', 'B1:B2', 'C1:I2','J1:P2']
multiHeader,//这⾥是第⼀⾏的表头
multiHeader2,//这⾥是第⼆⾏的表头
header: tHeader,//这⾥应该是算第三⾏的表头
data,
merges,
filename: this.filename
});
/
/ this.downloadLoading = false
});
},
formatJson(filterVal, jsonData) {
return jsonData.map(v =>
filterVal.map(j => {
if (j === "timestamp") {
return parseTime(v[j]);
);
},
},
Export2Excel.js，在此⽂件进⾏修改，
export function export_json_to_excel({
multiHeader = [],
multiHeader2 = [],//第三个参数
header,
data,
filename,
merges = [],
autoWidth = true,
bookType = 'xlsx'
} = {}) {
/
* original data */
filename = filename || 'excel-list'
data = [...data]
//此处是第三⾏⾏表头
data.unshift(header);
//此处是第⼆⾏表头
for (let i = multiHeader2.length - 1; i > -1; i--) {
data.unshift(multiHeader2[i])
}
//此处是第⼀⾏⾏表头
for (let i = multiHeader.length - 1; i > -1; i--) {
data.unshift(multiHeader[i])
}
Export2Excel.js  (全部代码，此⽂件是我修改后的)，如下：
/* eslint-disable */
import { saveAs } from 'file-saver'
import XLSX from 'xlsx'
function generateArray(table) {
var out = [];
var rows = table.querySelectorAll('tr');
var ranges = [];
for (var R = 0; R < rows.length; ++R) {
var outRow = [];
var row = rows[R];
var cell = columns[C];
var colspan = Attribute('colspan');
var rowspan = Attribute('rowspan');
var cellValue = cell.innerText;
if (cellValue !== "" && cellValue == +cellValue) cellValue = +cellValue;
//Skip ranges
ranges.forEach(function (range) {
if (R >= range.s.r && R <= && outRow.length >= range.s.c && outRow.length <= ) {          for (var i = 0; i <= - range.s.c; ++i) outRow.push(null);
}
});
//Handle Row Span
if (rowspan || colspan) {
rowspan = rowspan || 1;
colspan = colspan || 1;
ranges.push({
s: {
r: R,
c: outRow.length
},
e: {
r: R + rowspan - 1,
c: outRow.length + colspan - 1
}
});
};
//Handle Value
outRow.push(cellValue !== "" ? cellValue : null);
//Handle Colspan
if (colspan)
for (var k = 0; k < colspan - 1; ++k) outRow.push(null);
}
out.push(outRow);
}
return [out, ranges];
};
function datenum(v, date1904) {
if (date1904) v += 1462;
var epoch = Date.parse(v);
return (epoch - new Date(Date.UTC(1899, 11, 30))) / (24 * 60 * 60 * 1000);
}
function sheet_from_array_of_arrays(data, opts) {
var ws = {};
var range = {
s: {
c: 10000000,
r: 10000000
},
e: {
c: 0,
r: 0
}
};
for (var R = 0; R != data.length; ++R) {
for (var C = 0; C != data[R].length; ++C) {
if (range.s.r > R) range.s.r = R;
if (range.s.c > C) range.s.c = C;
var cell = {
v: data[R][C]
};
if (cell.v == null) continue;
var cell_ref = de_cell({
c: C,
r: R
});
if (typeof cell.v === 'number') cell.t = 'n';
else if (typeof cell.v === 'boolean') cell.t = 'b';
else if (cell.v instanceof Date) {
cell.t = 'n';
cell.z = XLSX.SSF._table[14];
cell.v = datenum(cell.v);
} else cell.t = 's';
ws[cell_ref] = cell;
}
}
if (range.s.c < 10000000) ws['!ref'] = de_range(range);  return ws;
}vue element admin
function Workbook() {
if (!(this instanceof Workbook)) return new Workbook();
this.SheetNames = [];
this.Sheets = {};
}
function s2ab(s) {
var buf = new ArrayBuffer(s.length);
var view = new Uint8Array(buf);
for (var i = 0; i != s.length; ++i) view[i] = s.charCodeAt(i) & 0xFF;
return buf;
}
export function export_table_to_excel(id) {
var theTable = ElementById(id);
var oo = generateArray(theTable);
var ranges = oo[1];
/* original data */
var data = oo[0];
var ws_name = "SheetJS";
var wb = new Workbook(),
ws = sheet_from_array_of_arrays(data);
/* add ranges to worksheet */
// ws['!cols'] = ['apple', 'banan'];
ws['!merges'] = ranges;
/* add worksheet to workbook */
wb.SheetNames.push(ws_name);
wb.Sheets[ws_name] = ws;
var wbout = XLSX.write(wb, {
bookType: 'xlsx',
bookSST: false,
type: 'binary'
});

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。