https://issues.apache.org/bugzilla/show_bug.cgi?id=52203
Bug #: 52203
Summary: java.lang.OutOfMemoryError: Java heap space when
reading .xlsx file with 1million rows by using
usermodel api
Product: POI
Version: 3.7
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
I try to read .xlsx file of 1 million rows by using usermodel api, the file
size is 11.2 MB, the jvm throw Exception :
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Arrays.java:2786)
at java.io.ByteArrayOutputStream.write(ByteArrayOutputStream.java:94)
at
org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource$FakeZipEntry.<init>(ZipInputStreamZipEntrySource.java:115)
at
org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:55)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:82)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:220)
at SXSSFWorkbookTest.test2(SXSSFWorkbookTest.java:51)
at SXSSFWorkbookTest.main(SXSSFWorkbookTest.java:37)
To resolve the issue, i use the eventmodel api, that is ok!.
But i want to know why the usermodel api take so much memory when parseing huge
rows file???
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
