nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Define white border in excel using BIRT Design API

ashish13

Hi,

I have to define the white border in my excel sheet using BIRT Design API. I am able to do the same for the table i am created by defining the style of each cell, but not able to change the border of the rest of the excel sheet. Is there any way to do the same.

Thanks in advance,
Ashish

Find more posts tagged with

Comments

mwilliams

I've never seen a solution to shutting off the grid lines in Excel besides turning them off manually after the report has been run. It may be something you'd have to edit the emitter to be able to do. Not 100% sure on that.

ashish13

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="98733" data-time="1333999095" data-date="09 April 2012 - 12:18 PM">
I've never seen a solution to shutting off the grid lines in Excel besides turning them off manually after the report has been run. It may be something you'd have to edit the emitter to be able to do. Not 100% sure on that. </blockquote>
 
 
Hi Michael, 
 
Thanks for your suggestion. I got the solution for hiding the grid line. We can hide the gridline by following code snippet: 
 
EXCELRenderOption options = new EXCELRenderOption(); 
options.setHideGridlines(true);

mwilliams

Oh, good. The option is already in the emitter! Is this with the standard XLS emitter? Or with one of the community plug-ins?

Yaytay

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="98782" data-time="1334082072" data-date="10 April 2012 - 11:21 AM">
Oh, good. The option is already in the emitter! Is this with the standard XLS emitter? Or with one of the community plug-ins? </blockquote>
The SpudSoft emitter does it with an option called "ExcelEmitter.DisplayGridlines". 
I guess I ought to try to support the standard render options too, where they exist. 
 
One added feature of the SpudSoft emitter is that the option can be specified as a UserProperty on an individual table, so you can have some sheets with gridlines and some without. 
 
I'm currently working on documenting all this. 
 
Jim

ashish13