Eclipse Community Forums: BIRT » Native excel file

Home » Archived » BIRT » Native excel file

Fri, 28 October 2011 08:07

Eclipse User

We are generating excel files by using the following API

EXCELRenderOption options = new EXCELRenderOption();
options.setHideGridlines(false);
options.setOfficeVersion("office2007");
options.setWrappingText(true);
options.setEnableMultipleSheet(false);
options.setOutputFormat("xls");
options.setOutputFileName("c:\\view\\test.xls"));
task1 = birtReportEngine.createRenderTask(document);
task1.setRenderOption(options);

The issue is this code is generating an XML Spreadsheet as opposed to Native XLS. Is there anyway, we can generate native excel file?

Thanks

[Updated on: Fri, 28 October 2011 08:08] by Moderator

Re: Native excel file [message #753774 is a reply to message #753696]

Fri, 28 October 2011 12:59

Eclipse User

The default xls emitter uses the wordML fromat. You may want to try the
tribix emitter.

http://birtworld.blogspot.com/2010/06/birt-excel-output.html
http://birtworld.blogspot.com/2011/07/replacing-default-birt-xls-emitter.html

Jason

On 10/28/2011 8:07 AM, sam wrote:
> We are generating excel files by using the following API
>
> EXCELRenderOption options = new EXCELRenderOption();
> options.setHideGridlines(false);
> options.setOfficeVersion("2007");
> options.setWrappingText(true);
> options.setEnableMultipleSheet(false);
> options.setOutputFormat("xls");
> options.setOutputFileName("c:\\view\test.xls"));
> task1 = birtReportEngine.createRenderTask(document);
> task1.setRenderOption(options);
>
> The issue is this code is generating an XML Spreadsheet as opposed to
> Native XLS. Is there anyway, we can generate native excel file?
>
> Thanks

Previous Topic:	checking date parameter and changing it to default
Next Topic:	birt not showing in ie 8.0

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 24 19:37:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter