poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From maitrey <maitrey0...@gmail.com>
Subject XSSFWorkbook throws outofMemoryError
Date Tue, 23 Jan 2018 14:22:13 GMT
My file is 50MB and I got outofMemoryError in this statement.
XSSFWorkbook workbook = new XSSFWorkbook(excelFilePath); 

this line causes to  java.lang.OutOfMemoryError: Java heap space

We have search and try to apply the solutions like SXSSF classes,
StreamReader classes and SAX parser.
But this needs big implementation in our application.
We have the heap memory to 2GB but still we get this error.

Is there any way to use this constuctor? 
we need workbook object. It is extensive used in application.
I know there are similar questions like this. I have also tried to apply
suggetions but it is not completly works in our case.

Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message