Export chart to Excel

I have a problem with exporting reports that contains charts to excel. Chart is not exported to excel. Is there any solution to export charts to Excel?
I use BIRT 2.2.

Find more posts tagged with

Comments

Virgil Dodson

Hi slobar123,<br />
<br />
In BIRT 2.2 the included XLS emitter does not produce charts with the output. I have seen a plug-in for BIRT called Tribix that has another XLS emitter that does bring the chart over... however the chart shows up as an image and is not a working chart once it reaches the XLS file. There is a reference to that project from this site at <a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/33-tribix-extended-emitters-for-birt/'>http://www.birt-exchange.com/devshare/designing-birt-reports/33-tribix-extended-emitters-for-birt/</a><br />
<br />
If you need to preserve the chart and formulas and multiple worksheets, etc., then have a look at the free e.Spreadsheet Designer at <a class='bbc_url' href='http://www.birt-exchange.com/products/spreadsheet-report-designer/'>http://www.birt-exchange.com/products/spreadsheet-report-designer/</a>

reporter08

i had download tribix already.But i did not know, how to config it.
My birt is 2.2. i had copied it under the path same as
org.eclipse.birt.report.engine.emitter.prototype.excel_*.
and remove this old jar.
but it still not work.

Virgil Dodson

I am not familiar with the Tribix installation, however, using the e.Spreadsheet Designer will be your best option to get charts into an Excel report. Spreadsheets created with the e.Spreadsheet Designer can have working charts (not just charts converted to pictures), plus multiple worksheets that can burst based on the data supplied, protected worksheets, outlining, conditional formatting, etc. The e.Spreadsheet designs can be used along side your BIRT reports if you are using the BIRT Deployment Kit or the iServer Express without any additional development. If you are using the open source BIRT web viewer then you can use the e.Spreadsheet Engine to deliver your spreadsheet reports from a Java Servlet in a similar fashion.