Im getting Corrupt excel file while opening the file in Excel.
private saveAsExcelFile(buffer: any, fileName: string): void {
const data: Blob = new Blob([buffer], {
type: EXCEL_TYPE
});
saveAs.saveAs(data, fileName + '_export_' + new Date().getTime() + EXCEL_EXTENSION);
}
public exportAsExcelFile(table:any, excelFileName: string): void {
const readyToExport = [
{ id: 1, name: 'a' },
{ id: 2, name: 'b' },
{ id: 3, name: 'c' }
];
const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(readyToExport);
const workbook: XLSX.WorkBook = { Sheets: { 'data': worksheet }, SheetNames: ['data'] };
const excelBuffer: any = XLSX.write(workbook, { bookType: 'xlsx', type: 'buffer' });
this.saveAsExcelFile(excelBuffer, excelFileName);
return;
}
PK��
"]�PÖ�|�Z� Z� � docProps/core.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
Im getting Corrupt excel file while opening the file in Excel.
Code:
The exported xlsx file starts with:
Version: 0.15.6
Excel version: 365MSO (16.0.12624.20422)