Thanks. I'll give that a try as well as upping the max heap. Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 9:47 PM To: [email protected] Subject: Re: HSSF out of memory errors
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: [EMAIL PROTECTED] > -- 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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
