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 < andr...@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 > >
