超简单实现导出excel时 把数据库字段状态为数字转换成汉字

1.写个工具类

public class StatusConverter implements Converter<Integer> {@Overridepublic Class supportJavaTypeKey() {return Integer.class;}@Overridepublic CellDataTypeEnum supportExcelTypeKey() {return CellDataTypeEnum.STRING;}@Overridepublic Integer convertToJavaData(CellData cellData, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {return cellData.getStringValue().equals("有效") ? 1 : 0;}@Overridepublic CellData convertToExcelData(Integer value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {return new CellData(value == 1 ? "有效" : "无效");}}

2.在导出对应表单里面的字段上面打注解

@ExcelProperty(value = "有效性", index = 4,converter = StatusConverter.class)private Integer validflag;主要是后面的 converter = StatusConverter.class

以上就可以了