Easy Excel 导出存在绿色角标问题[返回字段类型是数字,当时使用String来接收]

一、背景

　　Easy Excel 导出,发现excel 存在大量的绿色角标,很影响美观,如果个人使用可以设置wps或office 忽略检测警告,

　但是我是对业主的,所以这一方式对我不适用,只能通过代码的方式解决.

二、实现

通过以下创建一个 ExcelWriter ,实现去绿色角标的关键是使用easyExcel 自带的拦截器.

1	`ExcelWriter excelWriter = EasyExcel.write(byteArrayOutputStream).registerWriteHandler(new` `CustomCellWriteHandler()).withTemplate(resource.getInputStream()).build())`

拦截器写法

package me.zhengjie.modules.util;
 
import cn.hutool.core.util.NumberUtil;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.Head;
import com.alibaba.excel.metadata.data.WriteCellData;
import com.alibaba.excel.write.handler.CellWriteHandler;
import com.alibaba.excel.write.metadata.holder.WriteSheetHolder;
import com.alibaba.excel.write.metadata.holder.WriteTableHolder;
import org.apache.poi.ss.usermodel.Cell;
 
public class CustomCellWriteHandler implements CellWriteHandler {
    @Override
    public void afterCellDataConverted(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, WriteCellData<?> cellData, Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) {
        // 数据为纯数字时，设置单元格类型为数字
        String dataValue = cellData.getStringValue();
        if (NumberUtil.isNumber(dataValue)) {
            cellData.setType(CellDataTypeEnum.NUMBER);
            cellData.setNumberValue(NumberUtil.toBigDecimal(dataValue));
        }
    }
 
}