Hello, Has anyone bumped into this problem? Is it a problem with the code that produces the Excel?
Thanks! Mihaela ________________________________ From: mihaela<[email protected]> To: POI Users List <[email protected]> Sent: Wednesday, October 31, 2012 8:19 AM Subject: Corrupted Excels in 2007 format with large number of rows and columns produced with Apache POI Streaming Usermodel API Hello, I have taken the example from page: http://poi.apache.org/spreadsheet/how-to.html#sxssf and tried to create an Excel with 900 000 rows and 255 columns. When I try opening the generated file with Microsoft Excel 2007 I get an exception that it has found "unreadable content" and the file is opened only after the repairing phase. This doesn't happen when I keep the number of rows but I decrease the number of columns to 70, or when I decrease the number of rows and have a larger value for the columns. Is this a bug? I don't see what could be wrong with the code. Please find attach the project that I have created. Thank you in advance! Mihaela
