@Data
@JsonIgnoreProperties(ignoreUnknown = true)
public class ConfigVO {
    @ExcelProperty("表頭1")
    private String head1;
    @ExcelProperty("表頭2")
    private String head2;
}

EasyExcel.read(multipartFile.getInputStream(), ConfigVO.class, new ConfigListener(this)).sheet().doRead();

@Slf4j
public class ConfigListener extends AnalysisEventListener<ConfigVO> {
    private static int count = 0;
    List<ConfigVO> list = new ArrayList<>();
    // 此map用來存儲模板錯誤的提示,由于我的全局異常捕獲沒有處理在監(jiān)聽器內(nèi)拋出的異常信息,
    //所以就將數(shù)據(jù)挪到service層處理拋異常
    Map<String, String> errMap = new HashMap<>();
    @Autowired
    private IConfigService configcService;
    public ConfigListener(ConfigService configService) {
        this.configService = configService;
    }
    @Override
    public void invoke(ConfigVO configVO, AnalysisContext analysisContext) {
        count++;
        list.add(configVO);
    }
    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
        log.info("成功讀取" + count + "條數(shù)據(jù)");
        //保存讀取到的數(shù)據(jù)到serviceImpl處理
        configService.saveConfig(list, errMap);
    }
    @Override
    public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
       // 驗(yàn)證表頭
    String head1 = "表頭1";
    String head2 = "表頭2";
    if (headMap.size() <= 0) {
        errMap.put("msg", "導(dǎo)入的模板不符合,請檢查后重新導(dǎo)入!");
    }
    //value值才是表頭信息
    if (!headMap.containsValue(head1) || !headMap.containsValue(head2)) {
        errMap.put("msg", "導(dǎo)入的模板不符合,請檢查后重新導(dǎo)入!");
    }  
}
}

public void saveConfig(List<ConfigVO> list, Map<String, String> errMap) {
    //批量存儲數(shù)據(jù)的list
    List<ConfigVO> customerlist = new ArrayList<>();
    //提示錯誤的list
    List<Integer> errList = new ArrayList<>();
    //用來去重的map
    Map<String, Integer> map = new HashMap<>();
    //遍歷list進(jìn)行校驗(yàn)
    for (int i = 0; i < list.size(); i++) {
        //原因是因?yàn)槲蚁氆@取出錯的當(dāng)前行,但是excel表格是從1開始,一條數(shù)據(jù)就是2
        Integer count = 2;
        count = count + i;
        ConfigVO configVO = list.get(i);
        //判有無空數(shù)據(jù)
        if (!ObjectUtils.isEmpty(configVO.getHead1()) && !ObjectUtils.isEmpty(configVO.getHead2())) {
            //判類型是否錯誤
            if (("1").equals(configVO.getHead1()) || ("2").equals(configVO.getHead1())) {
                String customerName = configVO.getHead2();
                //去前后空格
                customerName = StrUtil.trim(customerName);
                //校驗(yàn)單個(gè)數(shù)據(jù)是否超出字?jǐn)?shù)限制
                if (customerName.length() > 255) {
                    errList.add(count);
                }
                //map去重的key
                String mapStr = configVO.getHead2() + ":" + configVO.getHead1();
                //去除excel中重復(fù)數(shù)據(jù)
                if (map.containsKey(mapStr)) {
                    //如果已經(jīng)有了,那說明有重復(fù)數(shù)據(jù),更新行數(shù)為最新的
                    map.put(mapStr, count);
                    //放到錯誤提示的list,遍歷展示錯誤
                    errList.add(map.get(mapStr));
                } else {
                    //沒有重復(fù)也放到map中便于去重
                    map.put(mapStr, count);
                    //放到需要存儲的list
                    customerlist.add(configVO);
                }
            } else {
                errList.add(count);
            }
        } else {
            errList.add(count);
        }
    }
    //判斷是否是錯誤模板
    if (!errMap.isEmpty()) {
        throw new CommonException(errMap.get("msg"));
    }
    //是否有導(dǎo)入錯誤的數(shù)據(jù)
    if (!errList.isEmpty()) {
        StringBuilder str = new StringBuilder();
        str.append("第");
        for (Integer err : errList) {
            str.append("" + err + "行,");
        }
        str.append("導(dǎo)入失敗，請確認(rèn)信息是否有誤或數(shù)據(jù)是否有重復(fù)");
        throw new CommonException(str.toString());
    } else {
        //需要存到數(shù)據(jù)庫的數(shù)據(jù)
        //查數(shù)據(jù)庫查是否已經(jīng)存在
        //存在就跳過,不存在就添加到list
        }
        //新增數(shù)據(jù)到數(shù)據(jù)庫
        }
    }
}

//獲取文件名+后綴
String filename = file.getOriginalFilename();
if (filename != null) {
    //獲取其后綴
    String extension = filename.substring(filename.lastIndexOf(".") + 1);
    if (!(extension.equals("xls") || extension.equals("xlsx"))) {
        //此處為自定義異常捕獲,可使用其他方式
        throw new CommonException("文件格式有誤,請檢查上傳文件格式!!");
    }
}

//校驗(yàn)導(dǎo)入的是空模板
try {
    InputStream inputStream = file.getInputStream();
    ExcelReader reader = ExcelUtil.getReader(inputStream, 0);
    int rowCount = reader.getRowCount();
    if (rowCount <= 1) {
        throw new CommonException("導(dǎo)入的為空模板,請檢查后重新導(dǎo)入!!");
    }
}catch (IOException e) {
    log.error("文件獲取失敗:{}", e);
    throw new CommonException(e.getMessage());
}

@Override
public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
    // 驗(yàn)證表頭
    String head1 = "表頭1";
    String head2 = "表頭2";
    if (headMap.size() <= 0) {
        errMap.put("msg", "導(dǎo)入的模板不符合,請檢查后重新導(dǎo)入!");
    }
    //value值才是表頭信息
    if (!headMap.containsValue(head1) || !headMap.containsValue(head2)) {
        errMap.put("msg", "導(dǎo)入的模板不符合,請檢查后重新導(dǎo)入!");
    }
}