Hi Philippe,
look out for out-of-memory in your runtime logs and if
there are some, try to increase memory portion for the
VM (maybe via command line argument like
-Xms128mb -Xmx512mb or analog appropriate for your
env).
Keep in mind the excel stops processing at 64736 (or
similar, 16 bit unsigned int -1).
hth, cu Stefan
> -----Ursprüngliche Nachricht-----
> Von: Philippe DesRosiers [SMTP:[EMAIL PROTECTED]
> Gesendet am: Mittwoch, 6. September 2006 18:04
> An: [email protected]
> Betreff: Handling very large Excel files with HSSF?
>
> I'm trying to open a very LARGE excel file (around 45 thousand rows, but
> only seven or eight columns), but HSSF seems to hang during the creation
> of
> the HSSFWorkbook. Here's some code:
>
> <snip>
> content = new FileInputStream(myFile);
> POIFSFileSystem fs = new POIFSFileSystem(content);
> HSSFWorkbook workbook = new HSSFWorkbook(fs); //code
> hangs
> on this line.
> </snip>
>
> Does anyone have any ideas? Does HSSF just not support large files? What
> is
> the largest file size supported? Can I enable logging in HSSF to get more
> information?
>
> thanks,
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
