This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes Writing large data using Apache POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Writing large data using Apache POI" Watch "Writing large data using Apache POI" New topic

Writing large data using Apache POI

Srikanth Kumar
Ranch Hand

Joined: Jun 04, 2008
Posts: 36
I am trying to write 20000 records in an excel sheet using Apache POI. When i try to do this the process is taking more than 7 minutes. Sometimes i even get the java.lang.OutOfMemoryError. my code simply writes the data retrieved from the database to the excel sheet.

I dint understand the problem in the code. is anything going wrong?
Thanks in advance.

[ November 25, 2008: Message edited by: Srikanth Kumar ]
[ November 27, 2008: Message edited by: Martijn Verburg ]

Srikanth Kumar
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 41124
POI is known to need a lot of memory (the reason for that is most likely the OLE document format, which is quite complex). Can you allocate a larger heap size to the JVM?

Ping & DNS - my free Android networking tools app
Don't get me started about those stupid light bulbs.
subject: Writing large data using Apache POI
Similar Threads
opening the excel sheet from servlet
Creating excel with add-on Bloomberg function using POI
JSP to Excel Conversion
facing diffculty to highlight background color of an excel cell which is not reflected in file
How to make POI HSSF support Chinese Encoding?