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

 

 

 

 

by Torsten Haase
Posted on Fri, 04/11/2014 - 14:48

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



 

0
by Kaushik Mishra Author
Posted on Mon, 04/14/2014 - 02:35

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

0
by Tricarico Romain
Posted on Mon, 06/16/2014 - 00:25

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

 

 

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock