导出时，不支持进一步处理单元格样式

版本：4.0.2
需求：有一个类属性 (String)aField 添加注解 @ExcelProperty(value = "aHead", index = 5)，填充赋值 "aVal;;;bVal"，实际应该填充 "aVal"，因为需要根据 bVal 的值来确定填充 aVal 时是否需要设置字体样式为红色。编写自定义CellWriteHandler如下：

```
public class SplitHandler implements CellWriteHandler {

private int dataStartColumn;// 处理数据列
    private CellStyle cellStyle;

public SplitHandler(int dataStartColumn) {
        this.dataStartColumn = dataStartColumn;
    }

@Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder,
                                 WriteTableHolder writeTableHolder,
                                 List<WriteCellData<?>> cellDataList,
                                 Cell cell,
                                 Head head,
                                 Integer relativeRowIndex,
                                 Boolean isHead) {
        // 表头处理
        if (isHead) {
            // 表头，不需要特殊处理
            return;
        }
        // 获取单元格列索引
        int columnIndex = cell.getColumnIndex();

if (columnIndex == dataStartColumn && cellStyle == null) {
            cellStyle = writeSheetHolder.getSheet().getWorkbook().createCellStyle();
            Font font = writeSheetHolder.getSheet().getWorkbook().createFont();
            font.setColor(IndexedColors.RED.getIndex());
            cellStyle.setFont(font);
        }

if (columnIndex == dataStartColumn) {
            // 重写
            String cellDataStringValue = cell.getStringCellValue();
            // aVal;;;bVal
            String[] split = cellDataStringValue.split(";;;");
            BigDecimal aB = new BigDecimal(split[0]);
            BigDecimal bB = new BigDecimal(split[1]);
            cell.setCellValue(aB.toString());
            if(aB.compareTo(bB) < 0) {
                cell.setCellStyle(cellStyle);
            }
        }
    }
}
```
结果就是及时走了 cell.setCellStyle(cellStyle); 仍无法生效

解决了加了代码`public class SplitHandler implements CellWriteHandler {

private int dataStartColumn;// 处理数据列
    private CellStyle cellStyle;

public SplitHandler(int dataStartColumn) {
        this.dataStartColumn = dataStartColumn;
    }

@Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder,
                                 WriteTableHolder writeTableHolder,
                                 List<WriteCellData<?>> cellDataList,
                                 Cell cell,
                                 Head head,
                                 Integer relativeRowIndex,
                                 Boolean isHead) {
        // 表头处理
        if (isHead) {
            // 表头，不需要特殊处理
            return;
        }
        // 获取单元格列索引
        int columnIndex = cell.getColumnIndex();

if (columnIndex == dataStartColumn && cellStyle == null) {
            cellStyle = writeSheetHolder.getSheet().getWorkbook().createCellStyle();
            Font font = writeSheetHolder.getSheet().getWorkbook().createFont();
            font.setColor(IndexedColors.RED.getIndex());
            cellStyle.setFont(font);
        }

if (columnIndex == dataStartColumn) {
            // 重写
            String cellDataStringValue = cell.getStringCellValue();
            // aVal;;;bVal
            String[] split = cellDataStringValue.split(";;;");
            BigDecimal aB = new BigDecimal(split[0]);
            BigDecimal bB = new BigDecimal(split[1]);
            cell.setCellValue(aB.toString());
            if(aB.compareTo(bB) < 0) {
                cell.setCellStyle(cellStyle);
                cellDataList.get(0).setWriteCellStyle(null);// 新加代码：清空表格准备设置的样式
            }
        }
    }
}`

easyexcel/easyexcel

Content Risk Flag

Comments (1)

easyexcel/easyexcel .gitee-modal { width: 500px !important; }

Content Risk Flag