Hi Greg, As you suggested, I had opened an issue at Bugzilla. Bug 61832 Regards Thamodharan B
On Nov 29, 2017 11:20 AM, "Thamodharan Balraj" <thamodharan...@gmail.com> wrote: Sure, will do that. On Nov 29, 2017 4:05 AM, "Greg Woolsey" <greg.wool...@gmail.com> wrote: > 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 < > thamodharan...@gmail.com> 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" <greg.wool...@gmail.com> 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 < >> 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 >> > >> >> >> >>