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: [email protected] For additional commands, e-mail: [email protected]
