File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 42965
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?
I agree. Here's the link:
subject: Writing large data using Apache POI
It's not a secret anymore!