Re: HSSF out of memory errors

[ac...@apache.org]

If this is read only then use the eventusermodel (that should get you to 
maybe 7mb for about a 4mb mostly numerical file).  64mb is the default 
max heap, you'd want to go UP not down.

Page, Michael A. wrote:
> I need to read excel spreadsheets with approx. 40 columns
> of data where the row size ranges from approx. 1000 - 20000
> rows. The code has no problems reading up to about 3000
> rows but above that gives the java.lang.OutOfMemory error.
> I have tried varsious -Xmx options of up to 64M with no
> success.
> 
> Regards,
> Mike
> 
> ***************************************************
> Michael Page
> Programmer/Data Analyst
> Toppan Photomasks Inc.
> Phone (office): 512-310-6008
> Phone (cell): 512-217-1274
> Fax: 512-310-6853
> Email: Michael.Page@photomask.com
> 


-- 
Andrew C. Oliver
SuperLink Software, Inc.

Java to Excel using POI
http://www.superlinksoftware.com/services/poi
Commercial support including features added/implemented, bugs fixed.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/