vue2根据表头及表格数据导出对应的excel表格

需要下载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();
}