TypeError: Cannot read properties of undefined (reading 'utils') at read_utf16
#2898
Closed
opened 3 weeks ago by brismuth
·
4 comments
No Branch/Tag Specified
master
sankhavaramsaitulasiram/feat-fix-2752
maybeswapnil/issue2737
gh-pages
scottysseus/2560_2
ivan-trusov/fix-basedate
nandanv2702/issue_1300
protobi/master
ThomasChan/master
grantfayvor/master
tom-groves/bug-1105/rounding-error
mgreter/master
v0.87
v0.9.9
v0.9.8
v0.9.7
v0.9.6
v0.9.5
v0.9.4
v0.9.3
v0.9.2
v0.9.13
v0.9.12
v0.9.11
v0.9.10
v0.9.1
v0.9.0
v0.8.8
v0.8.7
v0.8.6
v0.8.5
v0.8.4
v0.8.3
v0.8.2
v0.8.1
v0.8.0
v0.7.9
v0.7.7
v0.7.6-i
v0.7.6-h
v0.7.6-a
v0.7.6
v0.7.5
v0.7.4
v0.7.3
v0.7.2
v0.7.11
v0.7.10
v0.7.1
v0.5.9
v0.5.8
v0.5.7
v0.5.10
v0.5.0
v0.4.3
v0.18.6
v0.18.5
v0.18.4+deno
v0.18.4
v0.18.3
v0.18.2
v0.18.1
v0.18.0+deno
v0.17.5
v0.17.0
v0.16.8
v0.16.7
v0.16.6
v0.16.5
v0.16.3
v0.16.2
v0.16.1
v0.16.0
v0.15.6
v0.15.5
v0.15.2
v0.14.0
v0.13.5
v0.13.4
v0.13.3
v0.13.1
v0.13.0
v0.12.9
v0.12.8
v0.12.7
v0.12.6
v0.12.5
v0.12.4
v0.12.3
v0.12.2
v0.12.13
v0.12.12
v0.12.11
v0.12.10
v0.12.1
v0.12.0
v0.11.9
v0.11.8
v0.11.7
v0.11.6
v0.11.5
v0.11.4
v0.11.3
v0.11.2
v0.11.19
v0.11.18
v0.11.17
v0.11.16
v0.11.15
v0.11.14
v0.11.13
v0.11.12
v0.11.11
v0.11.10
v0.11.1
v0.11.0
v0.10.9
v0.10.8
v0.10.7
v0.10.6
v0.10.5
v0.10.4
v0.10.3
v0.10.2
v0.10.1
v0.10.0
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
Milestone
Set milestone
Clear milestone
No items
No Milestone
Projects
Set Project
Clear projects
No project
Assignees
Assign users
Clear assignees
No Assignees
2 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#2898
Reference in New Issue
There is no content yet.
Delete Branch '%!s(<nil>)'
Deleting a branch is permanent. It CANNOT be undone. Continue?
No
Yes
I'm using
xlsx
version 0.18.5.My application can read all CSVs except this one, and I can't figure out what's special about it. I received a CSV similar to this one from a customer who is using my application, and I was able to simplify it down to the current state and still reproduce the isse. I'm wondering if there's some kind of invalid header on the CSV, but I'm not sure how to check that.
This CSV causes XLSX to throw the error
TypeError: Cannot read properties of undefined (reading 'utils')
.I'm using react, and importing sheetjs like this:
and here's how I'm using it:
Here's the error stack:
I think the error is coming from this line:
https://github.com/SheetJS/sheetjs/blob/master/bits/87_read.js#L53
Thanks for the report! So we can reproduce locally, are you loading the encoding support as described in https://docs.sheetjs.com/docs/getting-started/installation/frameworks#encoding-support ? (in general, forcing UTF8 support should not require the codepage encoding library)
Hmm, no, I didn't see that section in the docs, so I'm just loading in
xlsx
as described in my post.I can try loading in the full codepage encoding library and see if that resolves the issue.
We'll take a closer look later today, but that specific error suggests that the internal codepage instance is defined but not shaped as expected. It is loaded by default when using CommonJS (nodejs require) but not loaded when using the ESM build.
I confirmed that adding
Resolved the issue with this particular CSV. Thanks for the pointer!