EasyExcel 自定义标题样式_abstractcellstylestrategy-CSDN博客

本文链接：https://blog.csdn.net/weixin_42559785/article/details/127225588

在使用EasyExcel时，由于展示数据是动态的，不能够使用注解类的方式，只能通过List<String<String>> head参数传递标题，但是这样的话，标题是没有地方设置样式的。

我们可以通过继承类AbstractCellStyleStrategy来设置标题的样式

import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.write.handler.CellWriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteTableHolder;
import com.alibaba.excel.write.style.AbstractCellStyleStrategy;
import org.apache.poi.ss.usermodel.*;
import java.util.List;

public class CustomCellWriteHandler2 extends AbstractCellStyleStrategy implements CellWriteHandler {

    @Override
    public void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Head head, Integer integer, Integer integer1, Boolean aBoolean) {
    }

    @Override
    public void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, List<CellData> list, Cell cell, Head head, Integer integer, Boolean aBoolean) {
    }

    @Override
    public void afterCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Cell cell, Head head, Integer integer, Boolean isHead) {
        if(isHead) {
            CellStyle style = writeSheetHolder.getSheet().getWorkbook().createCellStyle();
            style.setFillForegroundColor(IndexedColors.RED.getIndex());// 设置背景色
            style.setFillPattern(FillPatternType.SOLID_FOREGROUND);   cell.setCellStyle(style);
        }
    }

    @Override
    protected void initCellStyle(Workbook workbook) {
    }

    @Override
    protected void setHeadCellStyle(Cell cell, Head head, Integer integer) {

    }

    @Override
    protected void setContentCellStyle(Cell cell, Head head, Integer integer) {
    }

}

结果展示：