Women in Technology

Hear us Roar



Article:
  Reading and Writing Excel Files with POI
Subject:   Creating huge excel files using POI/HSSF
Date:   2003-12-17 23:49:08
From:   anonymous2
Hello,


Many thanks to all involved in POI whichis extremely useful to so many of us.


I am having a problem when I create very big Excel files (1 MB and above) using POI/HSSF. Can anyone advise how to avoid the following error:
"
Exception in thread "main" java.lang.OutOfMemoryError
<<no stack trace available>>
"


Is there any sort of limitation? If yes, can it be overcome.


Thank you.


Full Threads Newest First

Showing messages 1 through 4 of 4.

  • Creating huge excel files using POI/HSSF
    2007-02-21 06:25:46  sdoradla [View]

    hi anonymous2,
    for this problem did u find any answer from the floks. If you have, please send it. It is very urgent to me.
    Regards,
    sDoradla
    • Creating huge excel files using POI/HSSF
      2009-02-20 13:47:42  kishor kona [View]

      Me too facing similar problems with HSSF excel file creation for large excel file getting out of Memory and CPU Starvation. Can any one please send information on this.
      • Creating huge excel files using POI/HSSF
        2009-07-16 04:58:20  murthy bhat [View]

        I am facing a similar problem myself when I am trying to create an Excel file of even 10 k records with 10-20 columns. Has anyone found any solution for the problem ? or any work around . . .Because I have tried the other jxl and other jars, but still no results.Please note that I cannot increase my jvm memory.

        Any suggestions will be useful.
      • Creating huge excel files using POI/HSSF
        2009-09-16 23:32:24  dinesh.kumar [View]