alibaba/easyexcel

行背景色设置异常

Open

#3.674 aberto em 24 de jan. de 2024

Ver no GitHub
 (2 comments) (0 reactions) (0 assignees)Java (7.599 forks)batch import
help wanted

Métricas do repositório

Stars
 (33.728 stars)
Métricas de merge de PR
 (Nenhuma PRs mesclada em 30d)

Description

异常代码

  public class ForecastGrossRowWriteHandler2 implements RowWriteHandler {
    @Override
    public void afterRowDispose(RowWriteHandlerContext context) {
        Row row = context.getRow();
        Cell cell = row.getCell(8);
        CellStyle rowStyle = cell.getCellStyle();


        if (cell.toString().equals("流水")) {
            System.out.println("AA");
            rowStyle.setFillForegroundColor(IndexedColors.YELLOW.getIndex());
        } else {
            System.out.println("BB");
            rowStyle.setFillForegroundColor(IndexedColors.BLUE.getIndex());
        }
        rowStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        row.setRowStyle(rowStyle);
    }
}

异常提示

问题描述

导出的EXCEL全是背景蓝色 debug测试 System.out.println("AA")也是有执行的
正常应该红色还蓝色都有

Guia do colaborador