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.

by Robert Goldenbaum
Badge for 'Question Solver' achievement
Posted on Wed, 10/21/2015 - 08:34

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

by Jörg Döhrer Author
Posted on Wed, 10/21/2015 - 12:41

In reply to by rgoldenbaum

Hello Robert,

thank you, the color function works fine. I'll try the CellStyle later.

Best regards.


Featured achievement

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
  • Profile picture for user frankweise
  • Profile picture for user Henrik Buckler
  • Profile picture for user UffeK
  • SS
  • MZ
  • PacMan


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