Thamodharam, we use Apache POI 3.18 development snapshot and have no problem to create SXSSF workbooks of 300 MByte, with up to 1 Mill. Rows and around 40 columns. On the server, that took up to 20 GB of RAM. However, we were never able to open such files with Libre Office, Gnumeric or Excel (while plenty of resources were available on the client computer). The spreadsheet programs just freeze.
The interesting part is: We exactly the same framework, we are good to create SXSSF workbooks of 100 MByte (or less) which actually open in Libre Office and Gnumeric and Excel quite fast. We are not sure, if there is a limitation in the Spread Sheet programs or Apache POI hits a problem. Cheers On Wed, 2017-11-22 at 21:05 +0530, Thamodharan Balraj wrote: > Hi Everyone, > > I am trying to generate a excel with SXSSF workbook. The size of excel may > shoot to 200-300MB, whose row count will be 5,00,000 and column count will > be around 150 approximately..! I get content issue while opening such large > excel file. > The version which I am using is APACHE POI 3.9 > I had also tried with, 3.15 the same issue exist. > > System holds enough ram and disk space as per the requirement. > > 3.9 performance seems to better than other versions, Is there any way to > rule this issue out in that version.? > > Anyone, who has idea on above scenario, kindly help me to proceed further. > > Regards > Thamodharan B
