XLS column widths #591

New Issue

2017-03-13T11:19:31Z

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.

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}); ```

👍 2

sheeeeep commented

2017-03-28 03:05:57 +00:00

(Migrated from github.com)

It's ok, thank you very much.

Sign in to join this conversation.

No Label

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