Uncaught RangeError: Invalid array length #3043

New Issue

limingyang-t4f · 2023-12-12T10:16:05Z

limingyang-t4f commented

2023-12-12 10:16:05 +00:00

Using xlsx.write to write 50 columns and 46,000 rows of data results in an error when exporting to Excel, but exporting to CSV works fine.
The error message is:
Uncaught RangeError: Invalid array length
at Array.push () at utf8ToBytes (index.js:1720:1)
at byteLength (index.js:433:1) at fromString (index.js:230:1)
at from (index.js:134:1)
at push../node_modules/buffer/index.js.Buffer.from (index.js:149:1)

Using xlsx.write to write 50 columns and 46,000 rows of data results in an error when exporting to Excel, but exporting to CSV works fine. The error message is: Uncaught RangeError: Invalid array length at Array.push (<anonymous>) at utf8ToBytes (index.js:1720:1) at byteLength (index.js:433:1) at fromString (index.js:230:1) at from (index.js:134:1) at push../node_modules/buffer/index.js.Buffer.from (index.js:149:1)

sheetjs commented

2023-12-13 18:28:12 +00:00

That error points to an issue with a Buffer shim. If this is related to some integration with SheetJS CE, please take a closer look at how you are passing data (your integration code is likely using Buffer). If this is related to a SheetJS Pro build, send an email and we can take a closer look.

sheetjs closed this issue

2023-12-13 18:28:12 +00:00

Sign in to join this conversation.