Re: [birt-dev] Error in Excel Preview using BIRT all-in-one

[cavillarba <cavillarba@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx>
> 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@xxxxxxxxxxx
>> https://dev.eclipse.org/mailman/listinfo/birt-dev
>>
>>
> 
> 
> -- 
> -Act as if it were impossible to fail
> 
> _______________________________________________
> birt-dev mailing list
> birt-dev@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/birt-dev
> 
> 

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