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/
