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 Wed, 22 Nov 2017 20:01:24 GMT
Perhaps there are some other less obvious limits POI isn't checking.  There
is quite a list at

https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

On Wed, Nov 22, 2017 at 11:51 AM Andreas Reichel <
andreas@manticore-projects.com> wrote:

>
> On Wed, 2017-11-22 at 19:39 +0000, Greg Woolsey wrote:
> > 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.
>
> We have hit that limit and POI throws an exception (both in XSSF and
> SXSSF).
> The mysterious "Excel does not open" happens with files below the row
> limit, when the number of cells exceed a certain number. Not sure
> though what exactly that limit is.
>
> Cheers
>
>

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