XWPFTemplate（一）生成根据模板文件填充内容生成word文件

是一只不会游泳的鱼

已于 2024-02-22 17:34:58 修改

阅读量1.4w

点赞数 5

分类专栏： JAVA Spring 文章标签： java 开发语言

于 2022-05-13 09:38:19 首次发布

本文链接：https://blog.csdn.net/weixin_44150474/article/details/124745274

版权

数据查询 Map处理模板填充 XWPFTemplate HTTP响应

关键词由CSDN通过智能技术生成

JAVA 同时被 2 个专栏收录

12 篇文章 0 订阅

订阅专栏

Spring

7 篇文章 0 订阅

订阅专栏

1、查询数据放入Map


    @Override
    public Map<String, Object> generateReport(String id,String areaCode) {
        //查询主数据
        ProCheckSpecialDO p = proCheckSpecialMapper.generateReport(id,areaCode);
        Map<String, Object> map = new HashMap<>();
        map.put("deptName", p.getEleName());
        map.put("columnName", p.getLabel());
        map.put("errorTotal", p.getErrorTotal());
        map.put("title", p.getTitle());
        QueryWrapper qw = new QueryWrapper();
        qw.eq("bind_id",p.getId());
        qw.orderByAsc("create_time");
        //查询所有的关于当前遍历数据错误项
        try {
            List<Map<String, Object>> contentsList = new ArrayList<>();
            List<ProCheckSpecialErrorDO> errorDOS = specialErrorMapper.selectList(qw);
            for(ProCheckSpecialErrorDO error : errorDOS){
                Map<String,Object> content = new HashMap<>();
                content.put("contentText","问题描述："+error.getContent());
                ArrayList<LinkedHashMap> arrayList=new ArrayList();
                QueryWrapper imgQw = new QueryWrapper();
                imgQw.eq("parent_id",error.getId());
                imgQw.eq("bind_id",p.getId());
                List<ProCheckSpecialErrorImageDO> images = imageMapper.selectList(imgQw);
                for (ProCheckSpecialErrorImageDO i : images) {
                    LinkedHashMap m = new LinkedHashMap();
                    m.put("image", Pictures.ofStream(new FileInputStream(i.getFilePath()), PictureType.PNG)
                            .size(600, 330).create());
                    arrayList.add(m);
                }
                content.put("images",arrayList);
                contentsList.add(content);
            }
            map.put("contents",contentsList);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }
        return map;
    }

2、使用XWPFTemplate将数据填充的模板文件，并且向HttpServletResponse中写入


    @GetMapping("/generateReport")
    @ApiOperation("生成报告")
    public void generateReport(String id, String code, HttpServletResponse response) {
        OutputStream out = null;
        try {
            Map<String, Object> map = proCheckSpecialService.generateReport(id,code);
            String deptName = (String) map.get("deptName");
            out = response.getOutputStream();
            XWPFTemplate template = XWPFTemplate.compile(templatePath).render(map);
            template.write(out);
            response.setContentType("application/octet-stream");
            response.setHeader("Content-disposition","attachment;filename="+deptName+"报告.docx");
            response.addHeader("Access-Control-Expose-Headers", "Content-disposition");
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }finally {
            if(out != null){
                try {
                    out.flush();
                    out.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }