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

mmancosu picture mmancosu  路  3Comments

Alex0007 picture Alex0007  路  3Comments

jamesbillinger picture jamesbillinger  路  4Comments

gustavosimil picture gustavosimil  路  3Comments

eyalcohen4 picture eyalcohen4  路  3Comments