Apache POI Excel row color is only black and doesn't change

Question

I am trying to make excel files background one row white and other aqua color. But for some reason whatever I do the color always changes to black.

private void writeTable(Table table, Row row, CellStyle style){
    if(row.getRowNum() % 2 == 0) {
        style.setFillBackgroundColor(IndexedColors.AQUA.getIndex());
        style.setFillPattern(CellStyle.SOLID_FOREGROUND);
    }
    style.setWrapText(true);
    Cell cell = row.createCell(0);
    cell.setCellValue(table.index);
    cell.setCellStyle(style);

    //And it continues with other cells
}

It doesn't change whatever I do, even if I try GREY_25_PERCENT its completely black. Here's picture of my excel file

@java.nazif StackOverflow is based on the English language. Please do not use anything else. — Luciano van der Veekens, Sep 12 '17 at 10:30
@Gagravarr sadly no. I deleted all styles and created a new style but still had the same problem. Can there be a problem that Excel is fixed to Black & White colors or something? — Jeredriq Demas, Sep 12 '17 at 10:47
@SamedSivaslıoğlu I know it looks weird, but try using `setFillForegroundColor()` instead of `setFillBackgroundColor()` — Luciano van der Veekens, Sep 12 '17 at 11:43
Possible duplicate of [Setting foreground color for HSSFCellStyle is always coming out black](https://stackoverflow.com/questions/2803841/setting-foreground-color-for-hssfcellstyle-is-always-coming-out-black) — Luciano van der Veekens, Sep 12 '17 at 11:52
@LucianovanderVeekens I love you man:D if you post that as an answer I'd accept it. — Jeredriq Demas, Sep 12 '17 at 12:53

Luciano van der Veekens · Accepted Answer · 2017-09-12T13:06:28.770

2

It may seem counterintuitive, but using

style.setFillPattern(CellStyle.SOLID_FOREGROUND);

in combination with

style.setFillForegroundColor(IndexedColors.AQUA.getIndex());

sets the background color of a cell.

The cell background itself probably also consists of two layers: a foreground and a background.

edited Sep 12 '17 at 13:06

answered Sep 12 '17 at 12:57

Luciano van der Veekens

6,307
4
26
30

score 0 · Answer 2 · answered Jan 23 '20 at 12:36

0

Try using

style.setFillPattern(FillPatternType.SOLID_FOREGROUND);

instead of

style.setFillPattern(CellStyle.SOLID_FOREGROUND);

It works with Apache POI 4.1.1

answered Jan 23 '20 at 12:36

Apache POI Excel row color is only black and doesn't change

2 Answers2