Get emoty cells #79

New Issue

2014-07-01T15:23:39Z

volodymyrl commented

2014-07-01 15:23:39 +00:00

(Migrated from github.com)

Hi, can I get all cells(empty too)? I haven't found this possibility. Thanks!

SheetJSDev commented

2014-07-01 15:40:06 +00:00

(Migrated from github.com)

There are some cases where excel generates stub cells. To see those files, set the sheetStubs option to true.

There are other cases where Excel does not store the information, like jagged arrays:

A,,
B,C,
D,E,F
,G,H
,,I

In a case like this, Excel won't generate stubs for B1,C1,C2. Do you want to see cells for those as well?

Also, how do you want to handle merge cells? Should you see empty cells for the other parts of a merge?

There are some cases where excel generates stub cells. To see those files, set the [sheetStubs option](https://github.com/SheetJS/js-xlsx#parsing-options) to true. There are other cases where Excel does not store the information, like jagged arrays: ``` A,, B,C, D,E,F ,G,H ,,I ``` In a case like this, Excel won't generate stubs for B1,C1,C2. Do you want to see cells for those as well? Also, how do you want to handle merge cells? Should you see empty cells for the other parts of a merge?

volodymyrl commented

2014-07-03 14:31:32 +00:00

(Migrated from github.com)

Thanks @SheetJSDev , sheetStubs option help me.

elad commented

2014-09-14 13:38:31 +00:00

(Migrated from github.com)

Hello,

I guess I'm seeing the "other cases" behavior since I don't get empty cells even when setting sheetStubs to true. :)

I would like to see empty cells for such cases. I'm not sure I understand the question about merge cells though, could you please explain? (for me an empty cell is one that has nothing in it when looked at in Excel...)

Edit: A quick glance suggests this isn't so trivial to implement because the cell I'm interested in (I3) doesn't appear in the data if I try to print it in parse_ws_xml. I see H3 and J3, but nothing between them. Any idea if the missing information exists elsewhere, or if there's a better strategy than trying to figure how many columns were "skipped"?

Hello, I guess I'm seeing the "other cases" behavior since I don't get empty cells even when setting `sheetStubs` to `true`. :) I would like to see empty cells for such cases. I'm not sure I understand the question about merge cells though, could you please explain? (for me an empty cell is one that has nothing in it when looked at in Excel...) Edit: A quick glance suggests this isn't so trivial to implement because the cell I'm interested in (I3) doesn't appear in the `data` if I try to print it in `parse_ws_xml`. I see H3 and J3, but nothing between them. Any idea if the missing information exists elsewhere, or if there's a better strategy than trying to figure how many columns were "skipped"?

Sign in to join this conversation.