sheetName的改变

1. npm i xlsx

npm i xlsx

package.json 里面多个 ,

"xlsx": "^0.17.2"

2. 引用

import { saveAs } from 'file-saver';
import { utils, write } from 'xlsx';

3. 使用 sheetName这个就是要改的名字

 exportExcel() {
    const worksheet = utils.json_to_sheet(this.getExcelData());
    const workbook = { Sheets: { data: worksheet }, SheetNames: ['data'] };
    const excelBuffer: any = write(workbook, {
      bookType: 'xlsx',
      type: 'array',
    });
    this.saveAsExcelFile(excelBuffer, 'AgrregatedIssueUpdates');
  }

  saveAsExcelFile(buffer: any, fileName: string): void {
    let EXCEL_TYPE =
      'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8';
    let EXCEL_EXTENSION = '.xlsx';
    const data: Blob = new Blob([buffer], {
      type: EXCEL_TYPE,
    });
    saveAs(
      data,
      fileName + '_export_' + new Date().getTime() + EXCEL_EXTENSION
    );
  }