Export TypeScript to Excel with style

Question

I use xlsx to write data to xlsx file.

My code :

const worksheet: XLSX.WorkSheet = XLSX.utils.json_to_sheet(myData);
const workbook: XLSX.WorkBook = { Sheets: { 'mySheet': worksheet }, SheetNames: ['mySheet'] };
XLSX.writeFile(workbook, 'MyData.xlsx');.

I want to style the cell ,how and whether it can be done?

I tried to use s but it did not work:

worksheet['B1'].s = {font: {bold : true}};

EDIT

"The docs claim that's only available in the pro version"- This comment is true, I did not notice.

So my question is different:

Is there any other way to export to excel file with style?

@user184994. correct! I did not notice. Is there any other way to do that? I do not mind using another package. — Hodaya Shalom, Oct 28 '18 at 08:24
npm install xlsx-style --save The second answer: https://stackoverflow.com/questions/39177183/how-to-export-json-to-csv-or-excel-angular-2 — Len Tran, Nov 07 '18 at 02:55

score 0 · Answer 1 · answered Feb 25 '21 at 13:14

0

you can use exceljs package instead of xlsx in angular.

answered Feb 25 '21 at 13:14

Gunjan Shiyani

1

Export TypeScript to Excel with style

1 Answers1