alibaba/easyexcel

行背景色设置异常

Open

#3,674 opened on Jan 24, 2024

View on GitHub
 (2 comments) (0 reactions) (0 assignees)Java (7,599 forks)batch import
help wanted

Repository metrics

Stars
 (33,728 stars)
PR merge metrics
 (No merged PRs in 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")也是有执行的
正常应该红色还蓝色都有

Contributor guide