The OOXML/Excel 2007+ limit is 2^20 (1,048,576) rows per sheet. If you are trying to put 5 million rows on a single sheet, Excel will never open it.
POI streaming may not catch it (it should, but maybe that's the bug), but OOXML compliant apps (Excel, OpenOffice/LibreOffice, etc.) will consider it corrupt. I've written out workbooks with < 1M rows in the past, without using the streaming format even. I've just had to notice when I reached the max # on a sheet and start a new sheet at that point. See the properties of org.apache.poi.ss.SpreadsheetVersion.EXCEL2007 enum for version specific limits. On Wed, Nov 22, 2017 at 7:35 AM Thamodharan Balraj <thamodharan...@gmail.com> 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 >
