easyexcel导出excel模板

easyexcel导出excel模板

pom文件添加jar依赖

   <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>easyexcel</artifactId>
        <version>2.1.4</version>
    </dependency>

java代码

    @GetMapping("export")
    public void export(CivilizedLuckyDrawQuery query, HttpServletResponse response) {
        DataResult<DrawVO> luckyDrawVODataResult = luckyDrawService.queryCivilizedList(query);
        List<DrawVO> data = luckyDrawVODataResult.getData();
        try {
            String fileName = "excel命名_"+ LocalDateTime.now().format(DateTimeFormatter.ofPattern("yyyyMMddHHmmss"));
            String sheetName = "sheet命名";
            response.setContentType("application/vnd.ms-excel");
            response.setCharacterEncoding("utf-8");
            fileName = URLEncoder.encode(fileName, "UTF-8");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xls");
            EasyExcel.write(response.getOutputStream(), CivilizedLuckyDrawVO.class).sheet(sheetName).doWrite(data);
        } catch (IOException e) {
            log.error("导出异常，e: {}", e);
        }
    }