let sheetNames=[]; let sheetsList={}; const wb=XLSX.utils.book_new();for(let keyindata) { sheetNames.push(key); let columnHeader=columnHeaders[key]//此处是每个sheet的表头let temp=transferData(data[key], columnHeader); sheetsList[key]=XLSX.utils.aoa_to_sheet(temp); sheetsList[key][...
vueJSON数据导出为多个sheet表的excel⽂件 <!DOCTYPE html> Document // 数据 let data = { '基本信息': [{name: '李四', sex: 'nan', age: 12}], '成绩': [{class: '计算机', teacher: 'Mrs wang', score: 90}] }; let columnHeaders...