While trying to export the report in EXCEL i am getting the xml version of the report

Hi,

i am trying to export the report in Excel format. But it is not showing report data in the Excel file. It is giving XML version of report.

Attachig the image for your reference.

Is this problem anyway related to MS Office version?
Any Help is greatly appreciated

Waiting for your Reply

Thanks in Advance
Nikhil

Find more posts tagged with

Comments

mwilliams

Hi Nikhil,

What version of BIRT and MS Office are you using?

NikhilNaik

The report is created by using "Eclipse BIRT Designer Version 1.0.1" with Version "3.2.14".

The rptdesign file shows
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.14" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 1.0.1 Build <20051130-1157></property>

And we are using MS Office 2000.

Thanks
Nikhil

Virgil Dodson

Hi Nikhil,<br />
<br />
Eclipse BIRT 1.0.1 is quite a few years old now as BIRT is on 2.3.2 now, but in any case, the default Excel file output is the XML format. This XML version of the spreadsheet is supported by MS Office 2003 or higher, but not Office 2000. There is another XLS emitter plug-in that produces the binary XLS file format readable by Excel 97 and higher. You can get more info at <a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/33-tribix-extended-emitters-for-birt/#description'>Tribix - Extended Emitters for BIRT - Designs & Code - BIRT Exchange</a>