Reg: Grid lines in Excel files [message #761389] |
Tue, 06 December 2011 12:03  |
Eclipse User |
|
|
|
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 #761570 is a reply to message #761389] |
Tue, 06 December 2011 17:08   |
Eclipse User |
|
|
|
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 #761625 is a reply to message #761570] |
Tue, 06 December 2011 19:07   |
Eclipse User |
|
|
|
Jason,
Below is the environment in which our reports run:
Birt:3.7
Weblogic:10.0.2
Jdk:1.5
Linux
Oracle 1g.
We are generating usinng birt tld.Shall post sample rptdesign and 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   |
Eclipse User |
|
|
|
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   |
Eclipse User |
|
|
|
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] by Moderator Report message to a moderator
|
|
|
|
Re: Reg: Grid lines in Excel files [message #762900 is a reply to message #762888] |
Thu, 08 December 2011 19:30   |
Eclipse User |
|
|
|
Where did you download the native excel emitter from and what version
are you using?
Jason
On 12/8/2011 2:20 PM, kkp wrote:
> Jason,
>
> Could you please advise on how to get grid lines displayed in excel.
|
|
|
|
|
|
Re: Reg: Grid lines in Excel files [message #844641 is a reply to message #761389] |
Sat, 14 April 2012 07:14   |
Eclipse User |
|
|
|
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.
|
|
|
Re: Reg: Grid lines in Excel files [message #846978 is a reply to message #844641] |
Mon, 16 April 2012 23:12  |
Eclipse User |
|
|
|
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.04169 seconds