在使用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 {@Overridepublic void beforeCellCreate(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, Row row, Head head, Integer integer, Integer integer1, Boolean aBoolean) {}@Overridepublic void afterCellDispose(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, List<CellData> list, Cell cell, Head head, Integer integer, Boolean aBoolean) {}@Overridepublic 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);}}@Overrideprotected void initCellStyle(Workbook workbook) {}@Overrideprotected void setHeadCellStyle(Cell cell, Head head, Integer integer) {}@Overrideprotected void setContentCellStyle(Cell cell, Head head, Integer integer) {}}

結果展示：

?

總結

以上是生活随笔為你收集整理的EasyExcel 自定义标题样式的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。