SpringBoot的excel模板导出

咬紧牙关i

已于 2023-09-27 08:54:00 修改

阅读量403

点赞数

分类专栏：其他 java 文章标签： spring boot 后端 java

于 2023-09-27 08:52:06 首次发布

本文链接：https://blog.csdn.net/qq_44255146/article/details/133338035

版权

其他同时被 2 个专栏收录

29 篇文章 0 订阅

订阅专栏

java

19 篇文章 0 订阅

订阅专栏

Word的模板导出(参考：https://easyexcel.opensource.alibaba.com/docs/current/quickstart/fill)

创建有两个sheet的excel文件模板
将模板文件放入resource\templates/doc下
使用

    public void exportUavInfoExcel(HttpServletResponse response, CaseExportRPO caseExportRPO) throws IOException {

        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");
        response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode("无人机情况汇报.xls", "utf-8"));

        // 获取数据库数据
        List<Object> caseList = baseMapper.getList();
        List<UavAreaExcel> typeList = exportStatisticsHandle(typeMap);

		// 获取模板
        String templateFileName = new ClassPathResource("templates/doc/uavInfoExcel.xls").getFile().getAbsolutePath();

        try (ExcelWriter excelWriter = EasyExcel.write(response.getOutputStream()).withTemplate(templateFileName).build()) {
            WriteSheet writeSheet = EasyExcel.writerSheet("按区域").build();
            excelWriter.fill(areaList, writeSheet);
            WriteSheet writeSheet1 = EasyExcel.writerSheet("按类型").build();
            excelWriter.fill(typeList, writeSheet1);

            // 写入时间
            Map<String, Object> map = new HashMap<String, Object>();
            map.put("timeRange", DateUtil.date(caseExportRPO.getStartTime()).toString(DatePattern.CHINESE_DATE_PATTERN) + " 至 " + DateUtil.date(caseExportRPO.getEndTime()).toString(DatePattern.CHINESE_DATE_PATTERN));
            excelWriter.fill(map, writeSheet);
            excelWriter.fill(map, writeSheet1);

            excelWriter.finish();
        }



    }