OutOfMemory when reading large excel file

[spiderman510]

Follow your example, but i got OutOfMemory error if reading large excel file (1GB). Small one(200MB) still good. Here is the line throw error because of reading whole excel file and store to memory ReadableWorkbook wb = new ReadableWorkbook(is)

[rzymek]

Use the other constructor. The one that takes a File

On Fri, 5 Mar 2021, 05:53 spiderman510, [email protected] wrote:

Follow your example, but i got OutOfMemory error if reading large excel file (1GB). Small one(200MB) still good. Here is the line throw error because of reading whole excel file and store to memory ReadableWorkbook wb = new ReadableWorkbook(is)

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dhatim/fastexcel/issues/152, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA22E3Y5UZONLP7HXQL4D3LTCBPVRANCNFSM4YUQ6A4A .

[danmaidesenling]

Follow your example, but i got OutOfMemory error if reading large excel file (1GB). Small one(200MB) still good. Here is the line throw error because of reading whole excel file and store to memory ReadableWorkbook wb = new ReadableWorkbook(is)

@spiderman510 Have you fixed the OOM issue ?