Java Mailing List Archive

http://www.java2.5341.com/

Home » user.poi »

Running out of memory with large Excel files

mclovin

2008-10-02

Replies: Find Java Web Hosting

Author LoginPost Reply

Hello All,

I am having issues with generating large Excel files with POI. In a
nutshell, I seem to be running out of memory. The Excel file that fails is
quite large - 50,000 rows, 69 columns. I have tried to increase the Java
heap size for the JVM and that seems to help; but ultimately the large files
still fail. Does anyone have any tips/tricks to optimize the JVM, Garbage
Collection, or POI code that might help out my situation?

Thanks,
-Jim
--
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)

©2008 java2.5341.com - Jax Systems, LLC, U.S.A.