JD

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.

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

0
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.

0

Featured achievement

Rookie
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

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