无法使用angular 9在ie9中导出xlsx文件

Question

无法在角9中导出IE9中的xlsx文件以下是代码：

exportexcel(): void {
/* table id is passed over here */
let element = document.getElementById('excel-table');
const ws: XLSX.WorkSheet = XLSX.utils.table_to_sheet(element);
/* generate workbook and add the worksheet */
const wb: XLSX.WorkBook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, 'Sheet1');
/* save to file */
XLSX.writeFile(wb, this.fileName);
}

Answer 1

以下代码对我有效：

import * as FileSaver from 'file-saver';
import * as XLSX from 'xlsx';
exportexcel(): void {
let element = document.getElementById('excel-table');
const worksheet: XLSX.WorkSheet = XLSX.utils.table_to_sheet(element);
const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] };
const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
const blob: Blob = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8' });
FileSaver.saveAs(blob, 'Data.xlsx'));
}