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
1 Reply
-
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