poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Woolsey <greg.wool...@gmail.com>
Subject Re: Apache POI: Content Issue while processing huge excel file with SXSSF
Date Tue, 28 Nov 2017 22:34:57 GMT
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 <thamodharan247@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.woolsey@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 <
> thamodharan247@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
> >
>
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message