You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by naresh <d....@gmail.com> on 2011/06/02 10:50:48 UTC

Re: HSSF and XSSF memory usage, some numbers

Hi Nick,

I have used "BigGridDemo" from examples for writing data into ".xlsx" files.

I have tested with below sets of data:

1. Rows(<=480000) X Columns(155): Written successfully and I can open the
excel file successfully. File size 257MB.
2. Rows(>490000) X Columns(155): Written successfully and I cannot open the
excel file. File size: 525MB. Below is the error message it showing:
Excel found unreadable content in 'big-grid.xlsx'. Do you want to recover
the contents of this workbook? If you trust the cource of this workbook,
click Yes.

Do you have any idea what could be the problem. 
I am not understanding whether this problem is with Excel 2007 or my machine
configuration or the problem is with BigGridDemo itself.

Please help.

Thanks & Regards,
Naresh.D

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/HSSF-and-XSSF-memory-usage-some-numbers-tp4312784p4447474.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org