Error in Excel Preview using BIRT all-in-one

View: New views
3 Messages — Rating Filter:   Alert me  

Error in Excel Preview using BIRT all-in-one

by cavillarba :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Everyone, I successfully downloaded and install the BIRT all-in-one package from eclipse web-site in my computer and created the sample report. I can preview this report in all forms(html, PDF, Word and Postscript) but except in Excel(I'm using Office 2007). I received this error: "The file you are trying to open, 'Customers[6].xls', 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 problem with my eclipse installation? I only download/extract the file and save it to my computer. Pls. help. Thanks, CESAR

Re: Error in Excel Preview using BIRT all-in-one

by Kyle.Bober :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

This isĀ  due to the format of the Excel file generated by BIRT. BIRT generates it's Excel files in the SpreadSheetML format which was a horrible attempt at storing the Excel spreadsheets in XML. Now Office 2007 follows the Open XML format. If you want BIRT to generate true Excel Binary files you should use the open source Tribix project. http://sourceforge.net/projects/tribix/

-Kyle

On Sat, Oct 3, 2009 at 1:20 AM, cavillarba <cavillarba@...> wrote:
Hi Everyone, I successfully downloaded and install the BIRT all-in-one package from eclipse web-site in my computer and created the sample report. I can preview this report in all forms(html, PDF, Word and Postscript) but except in Excel(I'm using Office 2007). I received this error: "The file you are trying to open, 'Customers[6].xls', 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 problem with my eclipse installation? I only download/extract the file and save it to my computer. Pls. help. Thanks, CESAR

View this message in context: Error in Excel Preview using BIRT all-in-one
Sent from the Eclipse BIRT - Dev mailing list archive at Nabble.com.

_______________________________________________
birt-dev mailing list
birt-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-dev




--
-Act as if it were impossible to fail

_______________________________________________
birt-dev mailing list
birt-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-dev

Re: Error in Excel Preview using BIRT all-in-one

by cavillarba :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Kyle:

Thanks for your valuable input. I already downloaded the extended emitters and copy to my computers using the instructions below w/c I get from the Internet search. However, I had some minor problems, the drop-down options for XLS will no longer display in BIRT.

CESAR

To install:
===========
Dump it in the directory
ROOT\birt-rcp-report-designer\plugins\
org.uguess.birt.report.engine.emitter.xls_2.3.0.200807241457 with all its contents and subfolders. In the main root directory
you will find the xls-emitter.jar. Do not copy this to the root directory
of the plugins directory - it will not work.

You'll also need to get the recommended POI jar
and dump it in the lib directory

i.e. plugins\
org.uguess.birt.report.engine.emitter.xls_2.3.0.200807241457\lib\
poi-3.1-FINAL-20080629.jar

You'll also need to rename or delete the original
org.eclipse.birt.report.engine.emitter.prototype.excel_2.3.1.v20080917.jar

If you're using the All-In-One Version of BIRT an Eclipse Project
==================================
You do the exact same thing except you do these changes
in ECLIPSE_INSTALL\plugins folder

Kyle.Bober wrote:
This is  due to the format of the Excel file generated by BIRT. BIRT
generates it's Excel files in the SpreadSheetML format which was a horrible
attempt at storing the Excel spreadsheets in XML. Now Office 2007 follows
the Open XML format. If you want BIRT to generate true Excel Binary files
you should use the open source Tribix project.
http://sourceforge.net/projects/tribix/

-Kyle

On Sat, Oct 3, 2009 at 1:20 AM, cavillarba <cavillarba@spcpower.com> wrote:

> Hi Everyone, I successfully downloaded and install the BIRT all-in-one
> package from eclipse web-site in my computer and created the sample report.
> I can preview this report in all forms(html, PDF, Word and Postscript) but
> except in Excel(I'm using Office 2007). I received this error: "The file you
> are trying to open, 'Customers[6].xls', 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 problem with my eclipse installation? I only
> download/extract the file and save it to my computer. Pls. help. Thanks,
> CESAR
> ------------------------------
> View this message in context: Error in Excel Preview using BIRT all-in-one<http://www.nabble.com/Error-in-Excel-Preview-using-BIRT-all-in-one-tp25725420p25725420.html>
> Sent from the Eclipse BIRT - Dev mailing list archive<http://www.nabble.com/Eclipse-BIRT---Dev-f2270.html>at Nabble.com.
>
> _______________________________________________
> birt-dev mailing list
> birt-dev@eclipse.org
> https://dev.eclipse.org/mailman/listinfo/birt-dev
>
>


--
-Act as if it were impossible to fail

_______________________________________________
birt-dev mailing list
birt-dev@eclipse.org
https://dev.eclipse.org/mailman/listinfo/birt-dev