hutool导入excel

1，定义controller
 
  @PostMapping("/uploadExcel")
    @ApiOperation(value = "导入上传")
    public Result upload(@RequestParam("studentList") MultipartFile reqXls,HttpServletRequest request) {

            return service.readRequestXls(ExcelUtil.getReader(reqXls.getInputStream()));
      
    }

2读取excel详情


//第一行为表头，跨过，从第二行开始读取
        for (int i = 1; i < reader.getRowCount(); i++) {
            List<Object> curRow = reader.readRow(i);
            log.info("i {} curRow {}  " , i , curRow);
            if (StringUtils.isEmpty(curRow.get(0).toString().trim())) {
                return Result.error("第" + i + 1 + " 行 " + "name未填写，请填写姓名。");
            }
            boolean result = checkData(curRow);
            if (!result) {
                return Result.error("第" + i + 1 + " 行 " +
                curRow.get(0).toString() + "信息填写不全请补充。");
            }
          
             String name2= curRow.get(1).toString();
            String sex = curRow.get(2).toString();
            String birthday = curRow.get(3).toString();
          

}


   private boolean checkData(List<Object> list) {
        if (StringUtils.isEmpty(list.get(0).toString()) ||
        StringUtils.isEmpty(list.get(1).toString()) ||
        StringUtils.isEmpty(list.get(2).toString()) )) {
            return false;
        }
        return true;
    }