Sheetjs: Generate excel with styles in javascript

[magtuan]

hi, you could tell me how to generate an excel with styles, I generate the xlsx but I can not show the styles, but the cells object does contain the s parameter with the defined style.
I attach images of the code.
Thank you very much for your help.

function GenerateExcelFile(inData){
console.log("Generate");
wb = new Workbook();
wb.cellStyles=true;
ws = sheet_from_array_of_arrays(inData);
var ws_name = "Hoja1";

console.log("Datos: ",ws);
wb.SheetNames.push(ws_name);
ws.cellStyles=true;
wb.Sheets[ws_name] = ws;

var wbout = XLSX.write(wb, {bookType:'xlsx', bookSST:true,  type: 'binary'});

saveAs(new Blob([s2ab(wbout)],
    {type:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8"}),
    "Libro.xlsx");
//saveAs(new Blob([s2ab(wbout)],{type:"application/octet-stream"}), "Libro.xlsx")

}

[magtuan]

how do you have to report the s parameter of the cell?
Option 1: s: fill: {patterntype: ...}
Option 2: s: {patterntype ...}

Thank you very much

[afeezaziz]

@magtuan , have you found out on how to achieve this?

[SheetJSDev]

We offer this in the Pro compendium. Since companies have paid for the features already, it would be unfair to them if we turned around and made it available as open source. We have a longer comment in a gist.