Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
Birt runtime xls report warning
Migrateduser
<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>
Find more posts tagged with
Comments
There are no comments yet