|
Re: Reg: Grid lines in Excel files [message #761570 is a reply to message #761389] |
Tue, 06 December 2011 17:08 |
|
Can you reproduce with report against the sample db and post the report
and output? BTW what version of BIRT are you using?
Jason
On 12/6/2011 7:03 AM, kkp wrote:
> Hi,
>
> We are using Native Excel emitter to generate excel files and we are
> getting the xls files generated, but we are not getting any grid lines
> in the excel files.
>
> Below is the code used to generate the excel files:
>
> EXCELRenderOption options = new EXCELRenderOption();
> options.setOption("excelRenderOption.hideGridlines",false);
> options.setOption("fixed_column_width",true);
> options.setWrappingText(true);
> options.setEnableMultipleSheet(false);
> options.setEmitterID("org.eclipse.birt.report.engine.emitter.nativexls");
> options.setOutputFormat(ReportingConstants.OUTPUT_TYPE_XLS);
> options.setOutputFileName(buildDocumentName(workingFolder, jobBo,
> ReportingConstants.OUTPUT_TYPE_XLS));
> task1 = birtReportEngine.createRenderTask(document);
> task1.setRenderOption(options);
> task1.render();
>
>
> In spite of setting
> options.setOption("excelRenderOption.hideGridlines",false); we are
> getting grid lines in the excel.
>
> Any thoughts on how to get the grid lines in the excel file.
>
> Thanks,
> KKP
>
>
|
|
|
|
|
Re: Reg: Grid lines in Excel files [message #762232 is a reply to message #761977] |
Wed, 07 December 2011 18:37 |
|
I tried this with the re api and it worked for me. Can you look at the
attached output and source I used?
Jason
On 12/7/2011 6:25 AM, kkp wrote:
> Jason,
>
> Please find attached sample rptdesign and excel documents.
>
> Below is the environment in which our reports run:
>
> Birt:3.7
> Weblogic:10.0.2
> Jdk:1.5
> Linux
> Oracle 1g.
>
> Thanks,
> KKP
>
>
|
|
|
Re: Reg: Grid lines in Excel files [message #762431 is a reply to message #762232] |
Thu, 08 December 2011 03:36 |
harip kaligo Messages: 74 Registered: July 2011 |
Member |
|
|
Jason,
in the source you used, the excel is generated using default birt excel emitter api, we are using native excel emitter api and the version of re api is from birt 3.7.
Could you please try once with below code and let us know if its worked.
Also the grid lines from the xls file attached are not visible in excel2003 version.
EXCELRenderOption options = new EXCELRenderOption();
> options.setOption("excelRenderOption.hideGridlines",false);
> options.setOption("fixed_column_width",true);
> options.setWrappingText(true);
> options.setEnableMultipleSheet(false);
> options.setEmitterID("org.eclipse.birt.report.engine.emitter.nativexls");
> options.setOutputFormat(ReportingConstants.OUTPUT_TYPE_XLS);
> options.setOutputFileName(buildDocumentName(workingFolder, jobBo,
> ReportingConstants.OUTPUT_TYPE_XLS));
> task1 = birtReportEngine.createRenderTask(document);
> task1.setRenderOption(options);
> task1.render();
Thanks,
KKP
[Updated on: Thu, 08 December 2011 03:39] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: Reg: Grid lines in Excel files [message #846978 is a reply to message #844641] |
Mon, 16 April 2012 23:12 |
|
This worked for me. Can you try starting eclipse with the -clean option?
Jason
On 4/14/2012 3:14 AM, Abhijit Mising name wrote:
> I have tried using "Native Excel Emitter Plug-in for BIRT".I am using
> BIRT 3.7 and
> org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114. I
> have followed the following steps.
> 1) remove the following files
> • org.eclipse.birt.report.engine.emitter.prototype.excel_3.7.0.v20110602
> • org.eclipse.birt.report.engine.emitter.excel.config_3.7.0.v20110602
> from eclipse\plugins folder.
> 2) Copy
> org.eclipse.birt.report.engine.emitter.nativexls_1.0.0.201110122114.jar
> to eclipse\plugins folder. But the chart/image is not coming when I
> export the report in a excel file.
> Could anyone help me regarding this.
|
|
|
Powered by
FUDForum. Page generated in 0.04464 seconds