Hello,
I have 2 questions about how to use colors in Excel-Reports.
1. In BeginTable and TableCell I can set the color of font and backround with some constants like C_BLACK but is there a way to set an own color with RGB Values? I would like to use the company colors. (By the way is there an overview about the constants, if I click on "Possible pre-defined colors" in the ARIS help I get only the main site.)
2. Is it possible to set the border color of the cells? I would like to use the company colors, too.
Best regards.
Hi Jörg,
1) should be possible like this:
lColor = convRGB(217,217,217)
...
function convRGB(r, g, b) {
return (new java.awt.Color(r/255.0,g/255.0,b/255.0,1)).getRGB() & 0xFFFFFF
}
2) If you use a worksheet object, you can create cell styles and set this to the single cell:
createCellStyle ( XlsFont p_Font, short p_TopBorder, short p_RightBorder, short p_BottomBorder, short p_LeftBorder, int p_TopBorderColor, int p_RightBorderColor, int p_BottomBorderColor, int p_LeftBorderColor, short p_HorizontalAlignment, short p_VerticalAlignment, int p_BackgroundColor, int p_ForegroundColor, short p_FillPattern, short p_dataFormat, boolean p_bHidden, short p_indent, boolean p_bLocked, short p_rotation, boolean p_bWrapText )
BR Robert