Birt runtime xls report warning

frames88

<p>Hi </p><p> </p><p>I am having an issue with xls report. Using birt runtime 3.7.2 version and the report is generated successfully. But when I try to open the file in Microsoft Excel, it is showing the following warning:</p><p> </p><p>"The file you are trying to open, 'Test.xls', is in a different format than specified by this file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"</p><p> </p><p>Upon clicking the "Yes" button, I am able to see the report data. Even though the data is showing in excel, this warning message is not going very well with the users. How to get rid off this message?</p><p> </p><p>Here is my code in the runtime:</p><p>// HttpServletResponse respons</p><p>IRenderOption options = new RenderOption();</p><div>options.setOutputStream(response.getOutputStream());</div><div> </div><div>EXCELRenderOption excelOptions = new EXCELRenderOption(options);</div><div>excelOptions.setOutputFormat("xls");</div><div>response.setContentType("application/vnd.ms-excel");</div><div> </div><p> </p>

mwilliams

<p>This is due to the xml based xls emitted by the XLS emitter. You might try using the spudsoft xls emitter or native xls emitter from the devshare that were submitted in contests we've done in the past:</p><p> </p><p><a data-ipb='nomediaparse' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/downloads'>https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/downloads</a></p><p> </p><p><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/379-native-excel-emitter-plug-in-for-birt/'>http://developer.actuate.com/community/forum/index.php?/files/file/379-native-excel-emitter-plug-in-for-birt/</a></p><p> </p><p>BIRT Designer Professional has the best Excel emitter by far, including features like live Excel functions, pivot tables, etc. You can try it out by downloading a free trial of BDPro:</p><p> </p><p><a data-ipb='nomediaparse' href='http://www.actuate.com/resources/product-downloads/#designers'>http://www.actuate.com/resources/product-downloads/#designers</a></p><p> </p><p>Hope this helps.</p>