I need to generate an excel report with almost 60.000 lines and 30 columns.
But, while using SXSSF approach of Big Grid Demo (I got it from the SVN
trunk), I've found some issues.
When I try creating a xlsx file with 1000 lines, it's ok. But when I try to
create a file with 10.000 lines, when I try opening it, the Excel software
show up an error ("Excel found an unreadable content"). The software asks to
fix it, but when I do it, the software tells that it had changed a line (but
the sheet is shown completely empty). The interesting part is that when I
try opening it with Open Office, it open, but not completely.
Regarding the file, it makes use of some CellStyles and Merged Regions.
So, what can I do to solve this problem? Which approach should I follow?
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Apache-POI-3-8-SXSSFWorkbook-Unreadable-Content-tp4658852p4658852.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
