How to use XlsCellStyle()

Posted by Bernardo Rodrigues

Posted on Mon, 04/02/2012 - 14:04 in Professional ARIS

Hello,

I'm working on an Excel report and want to change a cell's style. However, whenever I call:

var style = new XlsCellStyle()

I get an error: "XlsCellStyle is not defined'.

I'm using the workbook APIs for the report..I just can't change the cell's style, otherwise everything is working great. This looks like a very simple thing to fix...any tips?

16.6k

by Ilya Seletkov

Posted on Wed, 04/04/2012 - 11:45

Hello!

As for me, I use the next code to change excell cell style:

var oOut = Context.createExcelWorkbook("123.xls"); //Color of the text in cell var oBlueFont = oOut.createFont(); oBlueFont.setColor(30); //Blue (10 for red) //Style of the cell var oBlueStyle = oOut.createCellStyle(oBlueFont, 0, 0, 0, 0, 0, 0, 0, 0, Constants.ALIGN_LEFT, Constants.ALIGN_CENTER, 0, 0, Constants.NO_FILL); oBlueStyle.setVerticalAlignment(Constants.VERTICAL_TOP); oBlueStyle.setWrapText(true); oBlueStyle.setBorderBottom(Constants.BORDER_THIN); oBlueStyle.setBorderTop(Constants.BORDER_THIN); oBlueStyle.setBorderLeft(Constants.BORDER_THIN); oBlueStyle.setBorderRight(Constants.BORDER_THIN); Hope, this helps.

by Ye Ding

Posted on Mon, 06/17/2019 - 14:17

Hello Ilya Seletkov,

I've tried your code and it's helpful.

A small question: how to know the font color number used to set the font color? (in your example Blue = 30 and Red = 10). These values are not the Aris constant value like Constants.C_BLUE.

Thanks!