TT

 

Hi,   I begin in Aris Script. In an Excel script, i would like to change the text's direction.    With the function tableCell, the text is in horizontal direction. I want to have a vertical direction.    I think i must use Workbook function, for setup the cell style, but i don't know use it...   Anybody would have a solution ?       Thanks for your answer,   Regards
by Fulu Ralioma
Posted on Tue, 11/20/2012 - 11:09

Hi Mr Trintignac,

In ARIS Script help, check the method createCellStyle, the value for p_rotation put 90 and that will align your values vertically.

Example:

var verticalCellStyle = myWorkbook.createCellStyle(font,Constants.BORDER_THIN,Constants.BORDER_THIN,Constants.BORDER_THIN,Constants.BORDER_THIN,Constants.C_BLACK,Constants.C_BLACK,Constants.C_BLACK,Constants.C_BLACK,Constants.ALIGN_LEFT, Constants.ALIGN_LEFT,Constants.C_BLACK,Constants.C_WHITE,Constants.NO_FILL,Constants.XL_CELL_DATAFORMAT_GENERAL,false, 0, false, 90, true);

You will have to set the style for the cell that you want to have the vertical text

Example:

var myRow = sheet.createRow(0);
myCell = myRow.createCell(0);           
myCell.setCellValue("Vertical");
myCell.setCellStyle(verticalCellStyle);

Fulu

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

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