sheet_to_json not generating keys for cells containing '#N/A' #1035

Closed
opened 2018-03-14 08:57:58 +00:00 by arijitkanrar · 1 comment
arijitkanrar commented 2018-03-14 08:57:58 +00:00 (Migrated from github.com)

To begin with, Thank you so much for this library! It has been a lifesaver!
I've been able to do so much with it.

Been stuck with an issue.
I've a large excel sheet (~5500 rows with around 35 columns).
Some columns have a value of '#N/A' (formula referring to a missing value) and some have the text '#N/A' in them.
When I use sheet_to_json with the option {defval : null} but the keys are missing in the generated JSON.

Any idea why it might be?

Thanks Again!

Arijit

To begin with, Thank you so much for this library! It has been a lifesaver! I've been able to do so much with it. Been stuck with an issue. I've a large excel sheet (~5500 rows with around 35 columns). Some columns have a value of '#N/A' (formula referring to a missing value) and some have the text '#N/A' in them. When I use sheet_to_json with the option {defval : null} but the keys are missing in the generated JSON. Any idea why it might be? Thanks Again! Arijit
SheetJSDev commented 2018-03-14 14:44:21 +00:00 (Migrated from github.com)

Currently, Error cells are explicitly suppressed, even if a default value is specified. That probably should be changed.

Currently, [Error cells are explicitly suppressed](https://github.com/SheetJS/js-xlsx/blob/master/bits/90_utils.js#L60), even if a default value is specified. That probably should be changed.
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#1035
No description provided.