I employ the xlsx package for writing data to an xlsx file.
This is 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 am interested in styling the cell contents. Is this possible and how can it be achieved?
I attempted using s without success:
worksheet['B1'].s = {font: {bold : true}};UPDATE
"The documentation states that feature is only available in the pro version" - This comment holds true, I was not aware of this.
Hence my revised question:
Are there any alternative methods for exporting to an excel file with styles applied?