1.首先引入hutool依赖
2.使用hutool工具将导入的excel文件数据转成实体类对象保存到数据库
@PostMapping("/import") public ResponseResult<Integer> importExcelData(@RequestParam("file") MultipartFile file) throws IOException { ExcelReader reader = ExcelUtil.getReader(file.getInputStream()); List<Vacation> vacationList = reader.readAll(Vacation.class); ResponseResult<Integer> result=new ResponseResult<>(); result.setData(vacationService.insertVacationList(vacationList)); return result; }