js根据给定数据生成excel

安装了file-saver和xlsx依赖库
npm install file-saver xlsx
yarn add file-saver xlsx

//引入依赖库
import * as FileSaver from 'file-saver'
import * as XLSX from 'xlsx'
 const data = this.tableData.map(item => (
        {公司名称: item.companyName,
        期间: item.period,
        是否收入不平: this.incomeContent(item),
        利润总额:item.profitTotal,
        系统暂估:item.systemProvisional,
        手动暂估:item.manualProvisional,
        银行负债:this.bankDebtContent(item),
        年累计收入:item.thisYearIncome
      }));
      const worksheet = XLSX.utils.json_to_sheet(data);
      const workbook = XLSX.utils.book_new();
      XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
      const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
      const blob = new Blob([new Uint8Array(excelBuffer)], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
      FileSaver.saveAs(blob, this.params.period+'异常公司' + '.xlsx');