aspose file tools*
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 Java 8 in Action this week in the Java 8 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
Author

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
SCJP 5, SCWCD 5, SCDJWS 5
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39578
    
  27
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 - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Writing large data using Apache POI
 
Similar Threads
facing diffculty to highlight background color of an excel cell which is not reflected in file
How to make POI HSSF support Chinese Encoding?
Creating excel with add-on Bloomberg function using POI
opening the excel sheet from servlet
JSP to Excel Conversion