Java (Apache POI) Detect cell bakground gold color

Question

I've been searching for this but I couldn't find a solution.

I have a workbook and I have to check if a cell has the Excel Gold color as background.

something like:

if(cell.getCellStyle().getFillForegroundColorColor().equals(gold) ){ then do something

I tried with HSSF and RGB colors but I can't get it work.

I really apreciate some help.

THanks!

Did you try printing out the colour that POI finds for the cell in question? — Gagravarr
Yes, but only as a short color. but I can't have the equals() working with short — Danyelous
What happens if you then look that short up in the palette, what colour does that give you? — Gagravarr

Sankumarsingh Sankumarsingh · Accepted Answer · 2013-06-22T05:53:21

You can use

 if(cell.getCellStyle().getFillForegroundColor()==HSSFColor.GOLD.index){
   //do whatever you want
 }