easyexcel 自定义格式化

最新推荐文章于 2025-08-01 23:12:39 发布

原创

最新推荐文章于 2025-08-01 23:12:39 发布 · 5k 阅读

1 ·

CC 4.0 BY-SA版权

easyexcel 自定义格式化

easyexcel默认不能转换localDateTime，自定义converter转换localDateTime

*******************

相关类与接口

Converter：T 为需要转换的java类型

public interface Converter<T> {

    Class supportJavaTypeKey();               //设置java类型
    CellDataTypeEnum supportExcelTypeKey();   //设置celldata类型

    T convertToJavaData(CellData var1, ExcelContentProperty var2, GlobalConfiguration var3) throws Exception;
    CellData convertToExcelData(T var1, ExcelContentProperty var2, GlobalConfiguration var3) throws Exception;
}

CellDataTypeEnum

public enum CellDataTypeEnum {
    STRING,
    DIRECT_STRING,
    NUMBER,
    BOOLEAN,
    EMPTY,
    ERROR,
    IMAGE;

CellData

public class CellData<T> extends AbstractCell {
    private CellDataTypeEnum type;
    private BigDecimal numberValue;
    private String stringValue;
    private Boolean booleanValue;
    private Boolean formula;
    private String formulaValue;
    private byte[] imageValue;
    private Integer dataFormat;
    private String dataFormatString;
    private T data;


*********
构造函数

    public CellData(CellData<T> other) {

    public CellData() {
    public CellData(T data) {
    public CellData(T da