Hello all,
Good Day!
i have to write more than 100000 rows in a excel sheet (file size more than 20 MB) via
java.
when i use XSSF, i am getting below Error.
java.lang.OutOfMemoryError: Java heap space
at org.apache.xmlbeans.impl.store.Saver$TextSaver.resize(Saver.java:1592)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.preEmit(Saver.java:1223)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.emit(Saver.java:1144)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.emitElement(Saver.java:926)
at org.apache.xmlbeans.impl.store.Saver.processElement(Saver.java:456)
at org.apache.xmlbeans.impl.store.Saver.process(Saver.java:307)
at org.apache.xmlbeans.impl.store.Saver$TextSaver.saveToString(Saver.java:1727)
at org.apache.xmlbeans.impl.store.Cursor._xmlText(Cursor.java:546)
at org.apache.xmlbeans.impl.store.Cursor.xmlText(Cursor.java:2436)
at org.apache.xmlbeans.impl.values.XmlObjectBase.xmlText(XmlObjectBase.java:1455)
at org.apache.xmlbeans.impl.values.XmlObjectBase.toString(XmlObjectBase.java:1440)
at org.apache.poi.xssf.model.SharedStringsTable.addEntry(SharedStringsTable.java:162)
at org.apache.poi.xssf.usermodel.XSSFCell.setCe
llValue(XSSFCell.java:304)
at org.apache.poi.xssf.usermodel.XSSFCell.setCellValue(XSSFCell.java:275)
at com.brocade.swportal.reports.util.ResultSetToExcel.writeCell(ResultSetToExcel.java:186)
at com.brocade.swportal.reports.util.ResultSetToExcel.writeCell(ResultSetToExcel.java:167)
at com.brocade.swportal.reports.util.ResultSetToExcel.generate(ResultSetToExcel.java:111)
at com.brocade.swportal.reports.util.ResultSetToExcel.generate(ResultSetToExcel.java:164)
when i use HSSF , i am getting the below Error.
java.lang.OutOfMemoryError: Java heap space
I have tried increasing the java heap size , by giving upto -Xms1500m -Xmx2048m
none of them helps.
can some one help in providing a solution for this?
thanks
Subbu