• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Ganesh Patekar

generate large XLS file using java

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
Saloon Keeper
Posts: 5801
146
Android Mac OS X Firefox Browser VI Editor Tomcat Server Safari
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.)
 
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
He does not suffer fools gladly. But this tiny ad does:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!