导入导出接口写法

添加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();  }