You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Sharma, Siddharth" <Si...@Staples.com> on 2004/10/12 16:55:59 UTC
Fill a gray background color in a cell in Excel
Hi
I am trying to create a cell with a background fill color of gray.
I used the hex value of gray "C2C2C2", as in the code below
grayStyle.setFillBackgroundColor((short)0xC2C2C2);
But it does not work.
Does anybody know how to set the right background color?
Thanks in advance
Sid
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Fill a gray background color in a cell in Excel
Posted by Andrew Kharchuk <ak...@ukraina.com>.
Use classes below
HSSFColor.AQUA, HSSFColor.BLACK, HSSFColor.BLUE, HSSFColor.BLUE_GREY,
HSSFColor.BRIGHT_GREEN, HSSFColor.BROWN, HSSFColor.CORAL,
HSSFColor.CORNFLOWER_BLUE, HSSFColor.DARK_BLUE, HSSFColor.DARK_GREEN,
HSSFColor.DARK_RED, HSSFColor.DARK_TEAL, HSSFColor.DARK_YELLOW,
HSSFColor.GOLD, HSSFColor.GREEN, HSSFColor.GREY_25_PERCENT,
HSSFColor.GREY_40_PERCENT, HSSFColor.GREY_50_PERCENT,
HSSFColor.GREY_80_PERCENT, HSSFColor.INDIGO, HSSFColor.LAVENDER,
HSSFColor.LEMON_CHIFFON, HSSFColor.LIGHT_BLUE,
HSSFColor.LIGHT_CORNFLOWER_BLUE, HSSFColor.LIGHT_GREEN,
HSSFColor.LIGHT_ORANGE, HSSFColor.LIGHT_TURQUOISE, HSSFColor.LIGHT_YELLOW,
HSSFColor.LIME, HSSFColor.MAROON, HSSFColor.OLIVE_GREEN, HSSFColor.ORANGE,
HSSFColor.ORCHID, HSSFColor.PALE_BLUE, HSSFColor.PINK, HSSFColor.PLUM,
HSSFColor.RED, HSSFColor.ROSE, HSSFColor.ROYAL_BLUE, HSSFColor.SEA_GREEN,
HSSFColor.SKY_BLUE, HSSFColor.TAN, HSSFColor.TEAL, HSSFColor.TURQUOISE,
HSSFColor.VIOLET, HSSFColor.WHITE, HSSFColor.YELLOW
For example,
grayStyle.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.getIndex());
----- Original Message -----
From: "Sharma, Siddharth" <Si...@Staples.com>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Tuesday, October 12, 2004 5:55 PM
Subject: Fill a gray background color in a cell in Excel
> Hi
>
> I am trying to create a cell with a background fill color of gray.
> I used the hex value of gray "C2C2C2", as in the code below
>
> grayStyle.setFillBackgroundColor((short)0xC2C2C2);
>
> But it does not work.
> Does anybody know how to set the right background color?
>
> Thanks in advance
> Sid
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org