Sheetjs: XLS column widths

Created on 13 Mar 2017  路  4Comments  路  Source: SheetJS/sheetjs

there is no ['!col'] in my worksheet.

var workbook = XLSX.readFile('inputFiles/data.xls'); const worksheet = workbook.Sheets.Sheet1;

Read Bug Style

Most helpful comment

@sheeeeep can you change the read line to:

var workbook = XLSX.readFile('inputFiles/data.xlsx', {cellStyles:true});

All 4 comments

Column widths are currently calculated only for XLSX and they are available at the key '!cols'.

Thanks.
After save to XLSX, still no ['!cols'] in my worksheet.
image

@sheeeeep can you change the read line to:

var workbook = XLSX.readFile('inputFiles/data.xlsx', {cellStyles:true});

It's ok, thank you very much.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

happy0088 picture happy0088  路  3Comments

m-ketan picture m-ketan  路  3Comments

jamesbillinger picture jamesbillinger  路  4Comments

jamespan0 picture jamespan0  路  3Comments

Sankrish picture Sankrish  路  4Comments