需求是根据list中属性值, 导出Excel表格内容中显示 对号 √ 查号 ×

1 实现

Converter 接口 重写 convertToExcelData 方法

public class SymbolConverter implements Converter<String> {

    /**
     * Convert Java objects to excel objects
     *
     * @param value               Java Data.NotNull.
     * @param contentProperty     Content property.Nullable.
     * @param globalConfiguration Global configuration.NotNull.
     * @return Data to put into a Excel
     * @throws Exception Exception.
     */
    @Override
    public WriteCellData<?> convertToExcelData(String value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) {
        Integer i = Integer.valueOf(value);
        WriteCellData<?> cellData = new WriteCellData<>(i > 0 ? "√" : "×");
        WriteCellStyle writeCellStyle = new WriteCellStyle();
        writeCellStyle.setHorizontalAlignment(HorizontalAlignment.CENTER);
        cellData.setWriteCellStyle(writeCellStyle);
        return cellData;
    }

}

2 在属性上使用注解