Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Reg: Grid lines in Excel files(Reg: Grid lines in Excel files)
Reg: Grid lines in Excel files [message #761389] Tue, 06 December 2011 12:03 Go to next message
harip kaligo is currently offline harip kaligo
Messages: 74
Registered: July 2011
Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
harip kaligo is currently offline harip kaligo
Messages: 74
Registered: July 2011
Member
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 #761977 is a reply to message #761389] Wed, 07 December 2011 11:25 Go to previous messageGo to next message
harip kaligo is currently offline harip kaligo
Messages: 74
Registered: July 2011
Member
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 #762232 is a reply to message #761977] Wed, 07 December 2011 18:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
harip kaligo is currently offline 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 #762888 is a reply to message #762431] Thu, 08 December 2011 19:20 Go to previous messageGo to next message
harip kaligo is currently offline harip kaligo
Messages: 74
Registered: July 2011
Member
Jason,

Could you please advise on how to get grid lines displayed in excel.
Re: Reg: Grid lines in Excel files [message #762900 is a reply to message #762888] Thu, 08 December 2011 19:30 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 #762902 is a reply to message #762900] Thu, 08 December 2011 19:38 Go to previous messageGo to next message
harip kaligo is currently offline harip kaligo
Messages: 74
Registered: July 2011
Member
I have downloaded from below link:

http://code.google.com/a/eclipselabs.org/p/native-excel-emitter-birt-plugin/
Re: Reg: Grid lines in Excel files [message #762912 is a reply to message #762902] Thu, 08 December 2011 19:56 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you use go to this page:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1421-native-excel-emitter-plugin-for-birt/

And ask the question in the comments?

Jason

On 12/8/2011 2:38 PM, kkp wrote:
> I have downloaded from below link:
>
> http://code.google.com/a/eclipselabs.org/p/native-excel-emitter-birt-plugin/
>
Re: Reg: Grid lines in Excel files [message #763214 is a reply to message #762912] Fri, 09 December 2011 11:10 Go to previous messageGo to next message
harip kaligo is currently offline harip kaligo
Messages: 74
Registered: July 2011
Member
Jason,

Thanks it worked.


-KKP
Re: Reg: Grid lines in Excel files [message #844641 is a reply to message #761389] Sat, 14 April 2012 07:14 Go to previous messageGo to next message
Abhijit Missing name is currently offline Abhijit Missing name
Messages: 2
Registered: September 2011
Junior Member
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 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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.
Previous Topic:Is there way to create accessible reports in BIRT?
Next Topic:Mapping a Single Report Param to 2 query params
Goto Forum:
  


Current Time: Sat Oct 25 03:35:48 GMT 2014

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

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