需要下载xlsx插件辅助 import XLSX from "xlsx"; //表格数据转excel exportFile(){ //表头中有一项为操作,导出的excel不需要,所以过滤 let dataHeader = this.calculateHeader.filter(item => item.label !== '操作') //表头的数据格式为[{label:"名字",prop:"name"}] const workbook = XLSX.utils.book_new(); const headers = dataHeader.map(header => header.label); const worksheet = XLSX.utils.aoa_to_sheet([headers]); // 导出的表格只需要展示对应的label
const data = this.emissionRange.map(row => dataHeader.map(header => { const prop = header.prop; let value = row[prop]; // 这里是根据表格的某一项数据id通过字典做映射 if (prop === 'unit') { value = this.getChannelName(value, this.unitsList) } if (prop === 'emissionTypeId') { value = this.getChannelName(value, this.options) } return value; }) );
XLSX.utils.sheet_add_aoa(worksheet, data, {origin: -1}); // 将数据添加到对应位置 //excel表格下方sheet的名字 XLSX.utils.book_append_sheet(workbook, worksheet, 'sheet名字'); const excelBuffer = XLSX.write(workbook, {bookType: 'xlsx', type: 'array'}); 下载excel表格 this.saveExcelFile(excelBuffer, '排放源数据.xlsx'); } saveExcelFile(buffer, filename){ const data = new Blob([buffer], {type: 'application/octet-stream'}); const link = document.createElement('a'); link.href = window.URL.createObjectURL(data); link.download = filename; link.click(); }