Native excel file [message #753696] |
Fri, 28 October 2011 12:07 |
sam va 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 |
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.02139 seconds