xls export failing for large data Birt 2.6.2

hiren01it

<p>We are using Birt 2.6.2 to generate the excel reports.</p><p> </p><p>We have two report design files(for two report types). </p><p> </p><p> </p><p>For one report design file, excel generation working fine for large data. It automatically adds new sheet in the excel. Its working properly.</p><p>For this we are using static design file.</p><p> </p><p>For another report design file, excel generation fails with following exception for large data(more than 67000 rows).  This design file is generated dynamic.</p><p>If the no. of rows are less than 65,000 then its working properly.</p><pre class="_prettyXprint _lang-">Caused by: java.lang.NegativeArraySizeException at org.eclipse.birt.report.engine.emitter.excel.layout.Page.synchronize(Page.java:744) at org.eclipse.birt.report.engine.emitter.excel.layout.ExcelLayoutEngine.endRow(ExcelLayoutEngine.java:492) at org.eclipse.birt.report.engine.emitter.excel.ExcelEmitter.endRow(ExcelEmitter.java:125)</pre><p>What could be the reason for above exception?</p><p>Is there anything wrong in design file or something wrong in my code?</p><p> </p><p> </p><p> </p>

micajblock

<p>No there is nothing wrong with your code. It is a limitation of Excel.</p><p> </p><p><a data-ipb='nomediaparse' href='http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx'>http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx</a></p&gt;