Home
Analytics
XLS Emitter on Birt standalone
user_1977
How to do it ?
I haven't found any information about it....
Now I've Birt standalone working...
Find more posts tagged with
Comments
user_1977
........................
user_1977
help........
mwilliams
Hi user_1977,
So, are you just using the BIRT engines without the designer?
Virgil Dodson
Hi user_1977,
If you are using the BIRT Report engine to run and render reports, then you can use a code sample similar to the one included.
If you are just using the BIRT Runtime to create XLS reports on the command line, then another post shows how to do that here:[thread]11788[/thread]
Otherwise, if you are using the BIRT open source viewer, Actuate Interactive Viewer with the iServer Express, then XLS format is just a URL option.
user_1977
I'm using RCP Designer (I don't need to install Eclipse).
birt-rcp-report-designer-2_3_0.zip
"Want a dedicated report designer?
Simple to use RCP Version of the BIRT Report Designer for report developers on the Windows platform.
Pre-requisites: Java 1.5 JDK/JRE"
I've tried with vdodson's help... but It doesnt' work, It works only for PDF/HTML.
I need an emitter to integrate with my Birt rcp designer.....
mwilliams
user_1977,
The BIRT RCP Designer has XLS as a standard output. Are you running the reports in another way than straight out of the RCP Designer?
user_1977
<blockquote class='ipsBlockquote' data-author="mwilliams"><p>user_1977,<br />
<br />
The BIRT RCP Designer has XLS as a standard output. Are you running the reports in another way than straight out of the RCP Designer?</p></blockquote>
<br />
I know that the BIRT RCP Designer has pdf and html as standard output.<br />
<br />
For ppt,xls and doc I need to have Office 2003.....because it creates an XML file that Office 2003 can manage....<br />
<br />
<br />
<a class='bbc_url' href='
http://wiki.eclipse.org/BIRT/FAQ/Output_Formats'>BIRT/FAQ/Output
Formats - Eclipsepedia</a> :<br />
<br />
"<br />
Q: What report output formats does BIRT support?<br />
<br />
Release 2.1 supports HTML, Paginated HTML and PDF.<br />
Release 2.2 support HTML, Paginated HTML, PDF, WORD, XLS, and PostScript<br />
<br />
Note that PDF generation uses iText. Check the BIRT install instructions for infomation on the specific version.<br />
<br />
Q: Why the XLS/DOC/PPT file generated by BIRT looks like an XML?<br />
<br />
BIRT uses office XML to generate the report to XLS/DOC/PPT, it is supported by Office 2003 or later. The user should install Office 2003 or later to open the generated XML. <br />
"
mwilliams
So, you don't have Office 2003 or later available?
mwilliams
You could also possibly give this a try:<br />
<br />
<a class='bbc_url' href='
http://sourceforge.net/project/showfiles.php?group_id=166446&package_id=189293'>SourceForge.net
: Files</a>
user_1977
<blockquote class='ipsBlockquote' data-author="mwilliams"><p>You could also possibly give this a try:<br />
<br />
<a class='bbc_url' href='
http://sourceforge.net/project/showfiles.php?group_id=166446&package_id=189293'>SourceForge.net
: Files</a></p></blockquote>
<br />
<br />
I don't have Office 2003 and I don't want to install Office 2003.<br />
<br />
I don't know HOW to integrate xls-emitter-bin on my RCP DESIGNER !
Virgil Dodson
Microsoft puts out compatibility packs to allow older versions of Office to read some newer 2003 and 2007 files formats. I did a quick search and found this link. <a class='bbc_url' href='
http://www.microsoft.com/downloads/details.aspx?FamilyID=CF196DF0-70E5-4595-8A98-370278F40C57&displaylang=en'>Download
details: Office File Converter Pack</a>
user_1977
<blockquote class='ipsBlockquote' data-author="vdodson"><p>Microsoft puts out compatibility packs to allow older versions of Office to read some newer 2003 and 2007 files formats. I did a quick search and found this link. <a class='bbc_url' href='
http://www.microsoft.com/downloads/details.aspx?FamilyID=CF196DF0-70E5-4595-8A98-370278F40C57&displaylang=en'>Download
details: Office File Converter Pack</a></p></blockquote>
<br />
ok...but , in this way, I need to install this converter on every workstation that wants to export in XLS format .... Isn't it ?
user_1977
...............
mwilliams
user_1977,
Most likely, yes.
user_1977
__________?______________
g2kuong
Hi,<br />
<br />
FYI - Hopefully this will give you some more insight:<br />
<br />
If you're using the bundled RCP BIRT Designer, there should<br />
already be a default XLS emitter plugin.<br />
<br />
It's under<br />
ROOTbirt-rcp-report-designerplugins<br />
org.eclipse.birt.report.engine.emitter.prototype.excel_2.3.1.v20080917.jar<br />
<br />
The RCP Designer should have the XLS option in the Preview option.<br />
<br />
===================================================<br />
<br />
To deploy the opensource Tribix XLS created by Shawn in <a class='bbc_url' href='
http://sourceforge.net/projects/tribix/'>SourceForge.net
: Tribix - Extended Emitters for BIRT</a> which IMHO is much better than the prototype, you can download the bin version of it. The example I'm using is the xls_2.3.0 release of it.<br />
<br />
To install:<br />
===========<br />
Dump it in the directory<br />
ROOTbirt-rcp-report-designerplugins<br />
org.uguess.birt.report.engine.emitter.xls_2.3.0.200807241457 with all its contents and subfolders. In the main root directory<br />
you will find the xls-emitter.jar. Do not copy this to the root directory<br />
of the plugins directory - it will not work.<br />
<br />
You'll also need to get the recommended POI jar <br />
and dump it in the lib directory<br />
<br />
i.e. plugins<br />
org.uguess.birt.report.engine.emitter.xls_2.3.0.200807241457lib<br />
poi-3.1-FINAL-20080629.jar<br />
<br />
You'll also need to rename or delete the original<br />
org.eclipse.birt.report.engine.emitter.prototype.excel_2.3.1.v20080917.jar<br />
<br />
If you're using the All-In-One Version of BIRT an Eclipse Project<br />
==================================<br />
You do the exact same thing except you do these changes<br />
in ECLIPSE_INSTALLplugins folder<br />
<br />
<br />
Regards,<br />
Anthony
Suri
Hi everybody.
I read from this forum about the Tribix solution to generate XLS files on many versions (I´m using Excel 2000). I have downloaded xls-emitter-bin_2.5.0.zip and extract this plugin file into the eclipse plugins directory. Then I downloaded Apache POI library (poi-bin-3.5-FINAL-20090928.zip) from apache site and put it in the /lib directory under the extracted plugin folder. Finally, I renamed the prototype jar file of excel.
I started BIRT Report Design successfuly but when I run a report as XLS, I get this error message: "+ org.eclipse.birt.report.service.api.ReportServiceException: Report engine fails to initialize xls emitter, please make sure required libraries for this emitter are installed."
What am I doing wrong? Which step did I miss?
I´m using BIRT 2.3.2 on Eclipse 3.4.2.
Thanks for any reply.
Regards,
Suri
Suri
I got it working only on eclipse Report Design.
I´ve downloaded the wrong version of tribix emitter. Now I get xls-emitter-bin_2.3.1.zip with the POI poi-3.2-FINAL-20081019.jar as indicated on the README file of the xls emitter.
The chalenge now is to make it work on BIRT Report Viewer. I tried to copy the emitter files and POI jar file to the plugin directory of birt viewer (...Tomcat 5.5webappsbirt-viewerWEB-INFplatformplugins) but it fails. Should I have to change anything programaticaly?
Any idea?
Regards,
Suri
