Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Native excel file
Native excel file [message #753696] Fri, 28 October 2011 12:07 Go to next message
sam va is currently offline sam vaFriend
Messages: 121
Registered: July 2011
Senior Member
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 12:08]

Report message to a moderator

Re: Native excel file [message #753774 is a reply to message #753696] Fri, 28 October 2011 16:59 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Tue Apr 23 12:46:16 GMT 2024

Powered by FUDForum. Page generated in 0.02139 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top