Set backgroundcolor HSSFRow

Question

I'm trying to change the color of the rows when the approvaldate is later as today. At that moment, the rows should be colored in Red...Any idea why this code isn't working?

//  Create a row and put some cells in it. Rows are 0 based.
Row = sheet.createRow((short) count);

if(wdContext.nodeRecallStore().getRecallStoreElementAt(i).getApprovaldate().after(today))
//  {
        HSSFCellStyle style = wb.createCellStyle();
        style.setFillBackgroundColor(new HSSFColor.RED().getIndex());
        Row.setRowStyle(style);

// }

Mirco · Answer 1 · 2014-05-14T09:37:10.980

0

This is a little bit confusing, but you have to set the foreground color and a fill pattern.

 final HSSFCellStyle cell = (HSSFCellStyle) workbook.createCellStyle();
    cell .setFillForegroundColor( ... );
    cell .setFillPattern(  CellStyle.SOLID_FOREGROUND );

Updated to CellStyle.SOLID_FOREGROUND

edited May 14 '14 at 09:37

answered May 14 '14 at 07:34

Mirco

2,940
5
34
57

style.setFillPattern(FillPatternType.SOLID_FOREGROUND); I'm getting the error that this function expects 'Short' instead of 'FillPatternType' – user3414861 May 14 '14 at 09:19
Sorry, use CellStyle.SOLID_FOREGROUND – Mirco May 14 '14 at 09:37

Set backgroundcolor HSSFRow

1 Answers1