Remove Gridlines from Excel Report

Hi Kaushik,

you can modify the lines between table cell using the command Output.SetFrameStyle(frame, width, style):

Example (removes all frame lines):

                p_output.SetFrameStyle( Constants.FRAME_TOP, 0, 0)

                p_output.SetFrameStyle( Constants.FRAME_LEFT, 0, 0)

                p_output.SetFrameStyle( Constants.FRAME_BOTTOM, 0, 0)

                p_output.SetFrameStyle( Constants.FRAME_RIGHT, 0, 0)



To reset the default, use

p_output.ResetFrameStyle()



BR, Torsten



 

Hi Torsten,

Thanks for your reply !! But this only solves the border issue, while I am talking about removing the GRIDLINES. I know it is possible through xlsStyleSheet, but I am using StandardOutputAPI and I am not sure how remove GRIDLINES.

If you see excel, we have a feature to set or reset the gridlines for a sheet. I want to remove all the gridlines and later for the table cell having data I can reset the framestyle.

Regards,
Kaushik

Hi,

The best way to generate an Excel file with specific format is to use a template with your script.

Just create an Excel file with the format you want and import it in your script category. Then use it to fill the template Excel file :

var fl = Context.getFile("statTemplate.xls", Constants.LOCATION_SCRIPT);

wb = Context.createExcelWorkbook("SuivieModel.xls", fl);

var shFr = this.wb.getSheetAt(0);

  

By this way, you can use an Excel file with specific format, containing macros, predifined formulas etc.

Hope it will help.

Best Regard.

Romain Tricarico

bpmap.fr