KM
Hi,
I have created an excel report which populates the folder structure from ARIS. I would like to remove the gridlines in this report from the region where data is not there.
Can you please help me out on the same?
Thanks in Advance !!!
Regards,
Kaushik
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
