Bug 50320 - Opening .xlsx file cosumes large memory space
Summary: Opening .xlsx file cosumes large memory space
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.7-FINAL
Hardware: PC Windows Server 2003
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2010-11-22 23:01 UTC by chentao
Modified: 2010-11-23 07:06 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description chentao 2010-11-22 23:01:06 UTC

When I open a .xlsx file in POI is see a lot of instance of class org.apache.xmlbeans.impl.store.Xobj. 
They take up a large space in the JVM( compare to the .xls file ).
Is it a bug in the memory usage when parsing OOXML files?
Or it is just a different in the implementation when parsing old and new excel files?
Comment 1 Nick Burch 2010-11-23 07:06:24 UTC
The XSSF UserModel needs more memory than the equivalent HSSF one, because it's XML based rather than records, and that uses more. If memory is a real issue, you'll want to do SAX based processing. http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api details how