我想修改单元格里的文本，任意字符的的颜色。为什么不生效

[body2k]

public class PartialRedTextHandler implements CellWriteHandler {

@Override
public void afterCellCreate(CellWriteHandlerContext context) {
    CellWriteHandler.super.afterCellCreate(context);
}

@Override
public void afterCellDispose(CellWriteHandlerContext context) {
    Cell cell = context.getCell();
    // 拿到poi的workbook
    Workbook workbook = context.getWriteWorkbookHolder().getWorkbook();
    CellStyle baseCellStyle = getBaseCellStyle(workbook);
    int rowIndex = cell.getRowIndex();
    // 只处理非表头行
    if (rowIndex == 0) {
        return;
    }
    // 如果内容不是字符串类型
    if (cell.getCellType() == CellType.STRING) {
        String stringValue = cell.getStringCellValue();
        XSSFRichTextString richString = new XSSFRichTextString(stringValue);
        Font font = workbook.createFont();
        font.setColor(IndexedColors.RED.getIndex());
        richString.applyFont(font);
        cell.setCellValue(richString);
    }
    cell.setCellStyle(baseCellStyle);
    context.getFirstCellData().setWriteCellStyle(null);

}

private CellStyle getBaseCellStyle(Workbook workbook) {
    CellStyle style = workbook.createCellStyle();
    // 设置表格内容垂直居中
    style.setVerticalAlignment(VerticalAlignment.CENTER);
    // 设置表格内容水平居中
    style.setAlignment(HorizontalAlignment.CENTER);
    style.setWrapText(true);
    return style;
}

}

[bengbengbalabalabeng]

You could try the following implementation (Please refer to: https://fesod.apache.org/docs/sheet/write/style#code-example-2):

public class PartialRedTextHandler implements CellWriteHandler {

    @Override
    public void afterCellDispose(CellWriteHandlerContext context) {
        if (BooleanUtils.isNotTrue(context.getHead())) {
            WriteCellData<?> cellData = context.getFirstCellData();
            WriteCellStyle writeCellStyle = cellData.getOrCreateStyle();
            writeCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
            writeCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
            writeCellStyle.setWrapped(true);

            if (context.getCell().getCellType() == CellType.STRING) {
                WriteFont writeFont = new WriteFont();
                writeFont.setColor(IndexedColors.RED.getIndex());
                writeCellStyle.setWriteFont(writeFont);
            }
        }
    }
}