Set Excel style (background) based on color object

Asked Sep 05 '14 at 15:36

Active Sep 09 '14 at 11:59

Viewed 142 times

I have a Color object of some color (Awt) I want to set background of excel with above color

Lets say I have some color green, now my excel background should be green color.

but hssfstyle.setFillForegroundColor(bgColor); method accept only short value as parameter.

Is there anyway to get short value(index of color for excel style ) from Color object

I am using HSSFCellStyle to set excel background.

edited Sep 09 '14 at 11:59

asked Sep 05 '14 at 15:36

Naveen Kocherla

1

Please show in your question the code that you've tried so far, along with any problems: error messages, exception stack traces, or a description of incorrect results. – rgettman Sep 05 '14 at 16:07
I don't have any idea to implement.... Plz tell me a way to achieve it – Naveen Kocherla Sep 05 '14 at 16:17
Please see the [Apache POI Quick Guide](http://poi.apache.org/spreadsheet/quick-guide.html#FillsAndFrills). – rgettman Sep 05 '14 at 16:22
This may help you... http://stackoverflow.com/a/17709121/624003 – Sankumarsingh Sep 05 '14 at 17:40
The above suggestions did not help me – Naveen Kocherla Sep 09 '14 at 11:59
1

possible duplicate of [Apply POI Custom color using 'Hexadecimal Color Codes' provided](http://stackoverflow.com/questions/11188840/apply-poi-custom-color-using-hexadecimal-color-codes-provided) – Gagravarr Sep 09 '14 at 13:12

0 Answers0