apache poi - CellStyle color cell

Question

After searching i found a solution on stackoverflow:

csFirstRow.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
csFirstRow.setFillPattern(CellStyle.SOLID_FOREGROUND);

But it seems to have no effect.

Reading and searching google / Poi Docs desnt help.

How to Colorize a Cell using apache Poi?

score 4 · Accepted Answer · edited May 23 '17 at 11:52

It seems to be unnessecary to set the Fill Background. It requires the "fillPattern"

csFirstRow.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
csFirstRow.setFillPattern(CellStyle.SOLID_FOREGROUND);

as javadoc says (setFillPattern)

setting to one fills the cell with the foreground color... No idea about other values

Now it works as it should

thanks to this helpfull answer on stackoverflow

1 Answers1