Eclipse Community Forums: BIRT » xls output and wrong file format on Excel 2007

Home » Archived » BIRT » xls output and wrong file format on Excel 2007

xls output and wrong file format on Excel 2007 [message #764481]

Mon, 12 December 2011 04:21

Eclipse User

Hi,

I read some topics on the "The file you are trying to open is of different format..." and I tried to make a filename-generator-impl that would produce .xlsx files but that didn't help either. Is there any way to control the response content-type headers?

Re: xls output and wrong file format on Excel 2007 [message #764699 is a reply to message #764481]

Mon, 12 December 2011 12:39

Eclipse User

Nicklas,

The content type is set in the plugin.xml for the emitter and the
extension used is set in the viewer.properties for the deployed viewer:

# [EXTENSION SETTING]
viewer.extension.html=html
viewer.extension.pdf=pdf
viewer.extension.postscript=ps
viewer.extension.doc=doc
viewer.extension.xls=xls
viewer.extension.ppt=ppt
viewer.extension.ods=ods
viewer.extension.odt=odt
viewer.extension.odp=odp

You could change both but I do not think it will work because the xls
emitter does not generate xlsx files.

Jason

On 12/12/2011 4:21 AM, Nicklas Karlsson wrote:
> Hi,
>
> I read some topics on the "The file you are trying to open is of
> different format..." and I tried to make a filename-generator-impl that
> would produce .xlsx files but that didn't help either. Is there any way
> to control the response content-type headers?

Re: xls output and wrong file format on Excel 2007 [message #764946 is a reply to message #764699]

Tue, 13 December 2011 01:26

Eclipse User

It doesn't? Strange, wonder why Excel is complaining then if the xls produced is an xls?

Thanks, I'll see what the xml tuning produces...

Re: xls output and wrong file format on Excel 2007 [message #765237 is a reply to message #764946]

Tue, 13 December 2011 12:19

Eclipse User

Nicklas,

It is producing a 2003 version of the xml format for excel.

Have a look at this bug:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=267988

You could also look at the tribix emitters or this entry
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/

Jason

On 12/13/2011 1:26 AM, Nicklas Karlsson wrote:
> It doesn't? Strange, wonder why Excel is complaining then if the xls
> produced is an xls?
>
> Thanks, I'll see what the xml tuning produces...

Previous Topic:	Missing hyperlink when report loaded from hyperlink
Next Topic:	Output issue with Flat file

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 26 11:04:30 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter