[Bug 66610] when invoke method XSSFWorkbook workbook = new XSSFWorkbook(File file) ,java.lang.OutOfMemoryError: Java heap space occurred

2023-05-22 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=66610

PJ Fanning  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 OS||All
 Resolution|--- |INFORMATIONPROVIDED

--- Comment #2 from PJ Fanning  ---
Reading a large xlsx file requires a lot of memory. Try increasing your Xmx
size.

There is also support for streaming the Excel data - see
https://poi.apache.org/components/spreadsheet/how-to.html and the 'XSSF and SAX
(Event API)' section in it.

There are external libs for stream reading that might be easier to use:
* https://github.com/pjfanning/excel-streaming-reader
* https://github.com/dhatim/fastexcel

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org

[Bug 66610] when invoke method XSSFWorkbook workbook = new XSSFWorkbook(File file) ,java.lang.OutOfMemoryError: Java heap space occurred

2023-05-21 Thread bugzilla 
https://bz.apache.org/bugzilla/show_bug.cgi?id=66610

--- Comment #1 from younger  ---
Created attachment 38564
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=38564=edit
The excel file mentioned above

-- 
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org