exceljs / exceljs/exceljs

Hello folks, Export functionality is working on local but not working on server why this is happening I don't understand ?

Open
#2,549 11 comments 1 reaction 0 assignees View on GitHub
Dominant language
JavaScript
Stars
15.5k
Forks
2k
PR merge metrics
No merged PRs in 30d

Description

generateExcelFile(res: any[]){
var response = res[0];
const workbook = new ExcelJS.Workbook();

//#region Common COC Worksheet
const commonCoCWorksheet = workbook.addWorksheet('worksheetA');
const commonCoCHeaders =['test1','test2','test3'];

const commonDtRow = commonCoCWorksheet.addRow(commonCoCHeaders);

commonDtRow.eachCell((cell) => {
cell.style = {
font : {bold: true},
fill: {
type: 'pattern',
pattern: 'solid',
fgColor: { argb: 'FFFFC000' },
bgColor: { argb: 'FFFFC000' }
}
};
});

const CommonCoCRows = response['commondatas'].map((row) => [row.test1,row.test2,row.test3]);

commonCoCWorksheet.addRows(CommonCoCRows);

commonCoCWorksheet.columns.forEach((column) => {
const values = column.values.map((cell) => cell.toString());
//const maxLength = Math.max(...values.map(value => value.length));
const maxLength = Math.max(...values.filter(str => typeof str === 'string' && str.length > 0).map(str => str.length));
column.width = maxLength + 5;
});

//#endregion


workbook.xlsx.writeBuffer().then((data:any) => {
console.log("workbook data lpgdom :", data);
const blob = new Blob([data], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });
console.log("workbook blob");
FileSaver.saveAs(blob, 'test.xlsx');
});
}

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.