Birt - generate xls report programmatically

Question

I am using Birt to generate XLS reports.

While opening the generated XLS file I got the following message

"The file you are trying to open, is in a different format than specified by the 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?"

Is there any way to solve this issue?

what version of BIRT are you using? – James Jenkins Dec 12 '13 at 12:43 — James Jenkins, Dec 12 '13 at 12:43

score 0 · Answer 1 · answered Dec 11 '13 at 17:09

0

You are trying to open an Excel 2003 report on a computer that has Excel 2010 installed. The message comes from Microsoft, not BIRT.

Other than clicking throught the warning messages there are two options.

Remove Excel 2003 and install Excel 2010 on the computer opening the report
Upgrade to BIRT 4.3 it can export as Excel 2010 (xlxs)

answered Dec 11 '13 at 17:09

James Jenkins

1,954
1
24
43

Thanks James for your reply :) Actually I only have a Excel 2007 only so this problem exist with Excel 2007 – User Dec 12 '13 at 11:42

score 0 · Answer 2 · answered Aug 03 '14 at 06:15

You are seeing the message because Birt built-in emitter does not output Excel format files, it outputs files in an XML format that Excel can understand, as a result newer versions of Excel complain whenever the files are opened.

To solve this you can use other emitters such as SpudSoft (this emitter is planned to replace the inbox emitter for BIRT 4.3)

Birt - generate xls report programmatically

2 Answers2