@Target(ElementType.FIELD)
@Retention(RetentionPolicy.RUNTIME)
public @interface ExcelSelected {
    /**
     * 碼表類型（如 trans_status）
     */
    String codeField();
}

CREATE TABLE sys_dict (
    type VARCHAR(50) COMMENT '碼表類型（如trans_status）',
    code VARCHAR(20) COMMENT '碼值',
    name VARCHAR(50) COMMENT '顯示名稱'
);

public class GlobalCodeConverter implements Converter<String> {

    private static final Map<String, Map<String, String>> CACHE = new ConcurrentHashMap<>();

    @Override
    public Class<String> supportJavaTypeKey() {
        return String.class;
    }

    @Override
    public CellDataTypeEnum supportExcelTypeKey() {
        return CellDataTypeEnum.STRING;
    }

    // 讀取Excel時(shí)的轉(zhuǎn)換（中文->碼值）
    @Override
    public String convertToJavaData(ReadConverterContext<?> context) {
        String cellValue = context.getReadCellData().getStringValue();
        Field field = context.getContentProperty().getField();
        ExcelSelected annotation = field.getAnnotation(ExcelSelected.class);

        if (annotation != null) {
            Map<String, String> codeMap = getCodeMap(annotation.codeField());
            return codeMap.entrySet().stream()
                    .filter(entry -> entry.getValue().equals(cellValue))
                    .map(Map.Entry::getKey)
                    .findFirst()
                    .orElse(null);
        }
        return cellValue;
    }

    // 寫入Excel時(shí)的轉(zhuǎn)換（碼值->中文）
    @Override
    public WriteCellData<String> convertToExcelData(WriteConverterContext<String> context) {
        String value = context.getValue();
        Field field = context.getContentProperty().getField();
        ExcelSelected annotation = field.getAnnotation(ExcelSelected.class);

        if (annotation != null) {
            Map<String, String> codeMap = getCodeMap(annotation.codeField());
            return new WriteCellData<>(codeMap.get(value));
        }
        return new WriteCellData<>(value);
    }

    // 獲取碼表數(shù)據(jù)
    private Map<String, String> getCodeMap(String codeType) {
        // 帶緩存的碼表查詢
        return CACHE.computeIfAbsent(codeType, k -> {
            // 實(shí)際查詢數(shù)據(jù)庫的代碼（示例）
            Map<String, String> map = new HashMap<>();
            map.put("1", "進(jìn)行中");
            map.put("2", "已完成");
            map.put("3", "已取消");
            return map;
        });
    }
}

public class OrderVO {
    @ExcelProperty("訂單狀態(tài)")
    @ExcelSelected(codeField = "trans_status")
    private String transStatus;
}

// 導(dǎo)出
EasyExcel.write(fileName, OrderVO.class)
         .registerConverter(new GlobalCodeConverter())
         .sheet().doWrite(orders);
// 導(dǎo)入
EasyExcel.read(fileName, OrderVO.class, new PageReadListener<>(list -> {}))
         .registerConverter(new GlobalCodeConverter())
         .sheet().doRead();