添加hutool依赖
<dependency> <groupId>cn.hutool</groupId> <artifactId>hutool-all</artifactId> <version>5.7.20</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.1.2</version> </dependency> /** * 导入 * @param file * @return * @throws IOException */ @PostMapping("import") public boolean imp(MultipartFile file) throws IOException { InputStream inputStream = file.getInputStream(); ExcelReader reader = ExcelUtil.getReader(inputStream); List<User> list = reader.readAll(User.class); return userService.saveBatch(list); } /** * 导出 * @param response * @throws IOException */ @GetMapping("export") public void export(HttpServletResponse response) throws IOException { List<User> list = userService.list(); ExcelWriter writer = ExcelUtil.getWriter(true); // writer.addHeaderAlias("username","用户名"); // writer.addHeaderAlias("password", "密码"); // writer.addHeaderAlias("nickname", "昵称"); // writer.addHeaderAlias("email", "邮箱"); // writer.addHeaderAlias("phone", "电话"); // writer.addHeaderAlias("address", "地址"); // writer.addHeaderAlias("createTime", "创建时间"); // writer.addHeaderAlias("avatarUrl", "头像"); // 一次性写出list内的对象到excel，使用默认样式，强制输出标题 writer.write(list, true); // 设置浏览器响应的格式 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8"); String fileName = URLEncoder.encode("用户信息", "UTF-8"); response.setHeader("Content-Disposition", "attachment;filename=" + fileName + ".xlsx"); ServletOutputStream out = response.getOutputStream(); writer.flush(out, true); out.close(); writer.close(); }