Bug 27181 - Unable to read large excel file
Summary: Unable to read large excel file
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.0.2
Hardware: HP All
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2004-02-24 02:13 UTC by Nirupam
Modified: 2008-10-30 13:46 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Nirupam 2004-02-24 02:13:41 UTC
I have a standalone program which reads any excel file and depending on the 
sheet name and line number and column number it generates tab deliminited text 

When I feed a small file it works file but when I tries to feed a file of 
3070kb it tell out of memory exception. I am using a properity file to specify 
my source and target file any help in this regard is highly appreciated

Comment 1 Jason Height 2004-02-24 02:30:12 UTC
HSSF is a memory hog. This is known. You can either increase the heap size or
for your application you may want to consider using the HSSF event model instead
of reading in the entire workbook. See
http://jakarta.apache.org/poi/faq.html#faq-N10011 also
http://jakarta.apache.org/poi/hssf/how-to.html in the event model part

Please upgrade to POI 2.0 though.


Comment 2 gopi 2007-02-22 07:56:37 UTC
It seems HSSF works with small mb of excel , but when 10 mb of file is under 
processing ,the request is hung. Can any body suggest any alternative for this.
Will Jexcel solve the problem ? do any body have implemented?
Comment 3 Josh Micich 2008-10-30 13:46:04 UTC
It's hard to be sure if your problem has been fixed with the recent changes
(see bug 15716).  Please supply an example spreadsheet if you re-open this bugzilla.