how to remove Gridlines in excel report

Hi,
 
how to remove Gridlines in excel report by using Birt 3.7.1 versions.
 
could you please any one having solutions about this issues and reply provide the solution.
 
Please find the attached report for more clarifications.
 
 
 
Regards,
Patra

try.xls

want report_try.xls

try.rptdesign

Find more posts tagged with

Comments

shamo

Take a look at this settings when exporting. hope it helps.

Patra

Hi Shamo,
 
I am not getting this options in my eclipse to select this check box "Hide gridlines" .
 
could you please explain more on this with screenshot, how to get this options in my Birt eclipse 3.7.1 versions.
 
 
Regards,
Pankaja

Patra

any body can help on this to resolve the issues, how to remove the gridlines in excel reports on Birt 3.7.1 versions.
 
 
Thanks,
Patra

JFreeman

The output dialogue shamo showed is from the commercial release using the commercial excel emitter.
 
On the open source side, this is going to depend on the excel emitter you are using. I do not believe the out of the box excel emitter with version 3.7.1 has an option to disable the excel sheets grid lines.
 
If you are using the spudsoft emitter, there is an option to turn off the grid lines:
<pre class="_prettyXprint _lang-js">
ExcelEmitter.DisplayGridlines = false;
</pre>
If you do not have the spudsoft emitter, you can find details about installing it here: <a data-ipb='nomediaparse' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/Home'>https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/wiki/Home</a>