Does SheetJS support the import of very large files? #2908

New Issue

musb · 2023-04-05T00:35:46Z

musb commented

2023-04-05 00:35:46 +00:00

I have tried to upload a file of 500,000 rows and 109 columns using the Live Grid Demo but it does not display the data. Is there a limit to the spreadsheet size SheetJS can load and render?

I have tried to upload a file of 500,000 rows and 109 columns using the [Live Grid Demo](https://oss.sheetjs.com/) but it does not display the data. Is there a limit to the spreadsheet size SheetJS can load and render?

sheetjs commented

2023-04-05 00:51:58 +00:00

V8 (the JS engine powering chromium/nodejs) enforces a string length limit of ~512MB. In practice that translates to ~50M numeric cells.

In a test with 500K Rows x 100 Columns created by setting each cell in the first row (A1:CV1) to 0 and filling the values down to row 500000 using series fill (e.g. C100=99, D10000 = 9999, etc), the generated XLSX file is ~139MB and it contains a worksheet xml ~1.64B characters. That is well above what the browser currently can support.

If this use case matters to you, please report an issue to the Chromium / V8 bug trackers.

Follow #61 for future updates on the limit.

V8 (the JS engine powering chromium/nodejs) enforces a string length limit of ~512MB. In practice that translates to ~50M numeric cells. In a test with 500K Rows x 100 Columns created by setting each cell in the first row (A1:CV1) to `0` and filling the values down to row 500000 using series fill (e.g. C100=99, D10000 = 9999, etc), the generated XLSX file is ~139MB and it contains a worksheet xml ~1.64B characters. That is well above what the browser currently can support. If this use case matters to you, please report an issue to the Chromium / V8 bug trackers. Follow https://git.sheetjs.com/sheetjs/sheetjs/issues/61 for future updates on the limit.

sheetjs closed this issue

2023-04-05 00:51:58 +00:00

Sign in to join this conversation.