Can you open an issue at https://bz.apache.org/bugzilla/enter_bug.cgi?product=POI
with sample code and/or a sample workbook showing the problem? That would help us reproduce it and track anything that requires a code change. On Tue, Nov 28, 2017 at 3:38 AM Thamodharan Balraj <[email protected]> wrote: > Hi Greg Woolsey, > > I am not trying to put 5 million record in a sheet, I just tried with 0.5 > million rows I.e (500,000 rows )with 150 column. > > As you also mentioned, I had refered the limits, I hadn't crossed/violated > any specification limits. > > Even I didn't apply any styles or format. > I just iterate and write a comman data of length 25 character in all the > cells. > > The workbook is done successful. But while opening it, I face the content > issue error. Please find the screenshot attached with the mail regarding to > it. > > Kindly help, if any one has idea on it. > > Regards > Thamodharan B > > > > On Nov 23, 2017 1:09 AM, "Greg Woolsey" <[email protected]> wrote: > > 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 < > [email protected]> > 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 > > > > > >
