XLS column widths #591

Closed
opened 2017-03-13 11:19:31 +00:00 by sheeeeep · 4 comments
sheeeeep commented 2017-03-13 11:19:31 +00:00 (Migrated from github.com)

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

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

there is no ['!col'] in my worksheet. ` var workbook = XLSX.readFile('inputFiles/data.xls'); const worksheet = workbook.Sheets.Sheet1; `
SheetJSDev commented 2017-03-13 13:32:51 +00:00 (Migrated from github.com)

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

Column widths are currently calculated only for XLSX and they are available at the key `'!cols'`.
sheeeeep commented 2017-03-27 08:34:37 +00:00 (Migrated from github.com)

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

Thanks. After save to XLSX, still no ['!cols'] in my worksheet. ![image](https://cloud.githubusercontent.com/assets/16912701/24347445/f0fd565a-130a-11e7-9b69-ecf1b45ce4d5.png)
SheetJSDev commented 2017-03-27 14:24:00 +00:00 (Migrated from github.com)

@sheeeeep can you change the read line to:

var workbook = XLSX.readFile('inputFiles/data.xlsx', {cellStyles:true});
@sheeeeep can you change the read line to: ```js var workbook = XLSX.readFile('inputFiles/data.xlsx', {cellStyles:true}); ```
sheeeeep commented 2017-03-28 03:05:57 +00:00 (Migrated from github.com)

It's ok, thank you very much.

It's ok, thank you very much.
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#591
No description provided.