EasyExcel导入导出枚举、自定义类型

1、枚举类型

@Getter
public enum StatusEnum {
   
    DAI_XIA_FA(0,"待下发"),
    CHU_ZHI_ZHONG(1,"处置中");
  
    StatusEnum(Integer code, String descp) {
        this.code = code;
        this.descp = descp;
    }

    //标记数据库存的值是code
    @EnumValue
    private final Integer code;
    //标记返回值，响应的json值
    @JsonValue
    private final String descp;

    @JsonCreator
    public static StatusEnum jsonCreator(String name){
        if(StringUtils.isNoneBlank(name)){
            for (StatusEnum item : values()) {
                if(item.code.equals(name.trim()) || name.trim().equals(item.descp)){
                    return item;
                }
            }
        }
        return null;
    }
}

 2、枚举转换

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.property.ExcelContentProperty;
import com.sll.enums.HealthCodeAlarmStatusEnum;

public class StatusConverter implements Converter<StatusEnum> {
    @Override
    public Class supportJavaTypeKey() {
        return null;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return null;
    }

    @Override
    public StatusEnum convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
// 导入的时候直接导入数字即可 不用操作
        if (cellData.toString().equals("0")) {
            return StatusEnum.DAI_XIA_FA;
        }else {
            return StatusEnum.CHU_ZHI_ZHONG;
        }
    }

//导出时转换
    @Override
    public CellData convertToExcelData(StatusEnum value, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
        return new CellData(value.getDescp());
    }
}

3、自定义类型转换

public class StatusConverter implements Converter<对象属性类型> {
    @Override
    public Class<对象属性类型> supportJavaTypeKey() {
//对象属性类型
        return 对象属性类型.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
//CellData属性类型
        return CellDataTypeEnum.XXX;
    }

//CellData转对象属性，导入时转换
    @Override
    public 对象属性类型 convertToJavaData(CellData cellData, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
        String value = cellData.getStringValue();
        if ("待下发".equals(value)) {
            return 0;
        } else if ("处置中".equals(value)) {
            return 1;
        }else {
            return null;
        }
    }

//对象属性转CellData，导出时转换
    @Override
    public CellData convertToExcelData(对象属性类型 value, ExcelContentProperty excelContentProperty, GlobalConfiguration globalConfiguration) throws Exception {
       // return new CellData(属性类型);
        if (value== null) {
            return new CellData("");
        }
        if (value == 0) {
            return new CellData("待下发");
        } else if (value == 1) {
            return new CellData("处置中");
        } else {
            return new CellData("");
        }
    }
}