https://issues.apache.org/bugzilla/show_bug.cgi?id=52203
ronwhite <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #1 from ronwhite <[email protected]> 2011-11-17 09:34:43 UTC --- (In reply to comment #0) > 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 : code: InputStream inp = new FileInputStream("100w.xlsx"); Workbook wb = WorkbookFactory.create(inp); 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]
