Hi,there.Could you do me a favor about big excel file issue? #2973

New Issue

crdro1621876969 · 2023-06-26T16:22:04Z

crdro1621876969 commented

2023-06-26 16:22:04 +00:00

@sheetjs,is there any way to read big excel file like stream,so i can handle data row by row.beacuse i would get a webPage crash by reading all excel data of 18m size into memory,it was showing up to 2G ram in task manager.

sheetjs commented

2023-06-26 17:39:17 +00:00

Try passing the option dense: true to the parser: https://docs.sheetjs.com/docs/demos/bigdata/stream#dense-mode

Try passing the option `dense: true` to the parser: https://docs.sheetjs.com/docs/demos/bigdata/stream#dense-mode

sheetjs commented

2023-09-25 20:53:54 +00:00

If "Dense Mode" (https://docs.sheetjs.com/docs/demos/bigdata/stream#dense-mode) does not help, please reopen with some information about the size of the dataset (how many columns? are they primary numeric or text?) and we can take a closer look.

sheetjs closed this issue

2023-09-25 20:53:54 +00:00

Sign in to join this conversation.