java通过easyExcel导出execl文档

一、使用的maven依赖

<!--EasyExcel相关依赖-->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>easyexcel</artifactId>
  <version>3.0.5</version>
</dependency>

二、导出的代码

@ApiOperation(value = "导出用户表的excel")
@GetMapping("/exportExcel")
public ApiCommonResponseVO exportExcel(HttpServletResponse response) throws IOException {
        List<User> userList = userService.list();
        //response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        // 设置文本内省
        response.setContentType("application/vnd.ms-excel");
        // 设置字符编码
        response.setCharacterEncoding("utf-8");
        // 设置响应头
        response.setHeader("Content-disposition", "attachment;filename=therapistCashWithdrawal.xlsx");
        EasyExcel.write(response.getOutputStream(), User.class).sheet("理疗师提现").doWrite(userList);
        return ApiCommonResponseVO.success();
}



/**
* 文件上传
* <p>1. 创建excel对应的实体对象 参照{@link UploadData}
* <p>2. 由于默认一行行的读取excel，所以需要创建excel一行一行的回调监听器，参照{@link UploadDataListener}
* <p>3. 直接读即可
*/
@PostMapping("upload")
@ResponseBody
public String upload(MultipartFile file) throws IOException {
        EasyExcel.read(file.getInputStream(), UploadData.class, new UploadDataListener(uploadDAO)).sheet().doRead();
        return "success";
}

三、网址

关于Easyexcel | Easy Excel