//导出包含多Sheet的Excel文件
export function export2ExcelMultiSheet(jsonData, defaultTitle) {
/* original data */
var data = jsonData;
//添加标题
for(var item of data) {
item.data.unshift(item.th);
}
var wb = new Workbook();
//生成多个sheet
for(var item of data) {
wb.SheetNames.push(item.sheetTitle);
wb.Sheets[item.sheetTitle] = sheet_from_array_of_arrays(item.data);
}
var wbout = XLSX.write(wb, { bookType: “xlsx”, bookSST: false, type: “binary” });
var title = defaultTitle || “列表”;
saveAs(new Blob([s2ab(wbout)], { type: “application/octet-stream” }), title + “.xlsx”);
}