wood burning stoves 2.0
The moose likes Other Open Source Projects and the fly likes generate large XLS file using java 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 "generate large XLS file using java" Watch "generate large XLS file using java" New topic

generate large XLS file using java

rocker Joshi

Joined: Dec 23, 2011
Posts: 1
I need to generate a XLS-2003 file which may contain 65K rows and 230 columns using a simple XLS template file. Data will be picked up from standard tab seperated data file.
After generating Excel excel , I want to format that excel file and run some macros on that.

I tried LightCells API from Aspose , HSSF POI 3.0.7, JExcel.

But it is throwing :- java.lang.OutOfMemoryError: Java heap space
Is there any way to achieve this ?
Tim Moores

Joined: Sep 21, 2011
Posts: 2413
POI needs a lot of memory, particularly for large spreadsheets. Try giving the JVM more memory (maybe 512MB or 1GB). (And, of course, update to a newer version of POI - 3.0 has been obsolete for years.)
Shahzad Latif

Joined: Apr 28, 2011
Posts: 28
Do all the components throw this exception? Looks like you either have a very large Excel file or low heap space allocated. As suggested earlier, please try to increase the heap space. Moreover, if you still find the issue with Aspose.Cells for Java, you may contact our support team via Aspose.Cells forum; we will have to investigate whether it is the size of the PDF file or particular structure which is causing the problem.

Developer Evangelist @ Aspose. I love to explore and learn new technologies and help other developers along the way.
I agree. Here's the link: http://aspose.com/file-tools
subject: generate large XLS file using java
It's not a secret anymore!