easypoi导出纵向合并列，模版导出纵向合并相同数据

最新推荐文章于 2024-09-26 15:01:35 发布

来自外太空的鱼-张小张

最新推荐文章于 2024-09-26 15:01:35 发布

阅读量502

点赞数

文章标签： java 开发语言

本文链接：https://blog.csdn.net/qq_26144365/article/details/132107134

版权

public void exportExcel(String month, HttpServletResponse response) {
        List<ChamberInfoVo> chamberInfoVoList = this.tableStatistics(month);
        TemplateExportParams params = new TemplateExportParams();
        if (chamberInfoVoList.size() > 0) {
            try {
                response.setContentType("application/octet-stream");
                //取到要生成的模板
                try {
                    params = new TemplateExportParams(quantityStatisticsPath, true);
                } catch (Exception e) {
                    throw new RuntimeException("模板路径不存在！");
                }
                Map<String, Object> map = new HashMap<>();
                map.put("date", month);
                List<Map<String, String>> listMap = new ArrayList<Map<String, String>>();
                int approvedNumberTotal = 0;
                int issueddNumberTotal = 0;
                for (ChamberInfoVo chamberInfoVo : chamberInfoVoList) {
                    approvedNumberTotal = approvedNumberTotal + Integer.valueOf(chamberInfoVo.getApprovedNumber());
                    issueddNumberTotal = issueddNumberTotal + Integer.valueOf(chamberInfoVo.getIssuedNumber());
                    Map<String, String> lm = new HashMap<String, String>();
                    lm.put("deptName", chamberInfoVo.getDeptName());
                    lm.put("chamberName", chamberInfoVo.getChamberName());
                    lm.put("approvedNumber", chamberInfoVo.getApprovedNumber());
                    lm.put("issueddNumber", chamberInfoVo.getIssuedNumber());
                    listMap.add(lm);
                }
                map.put("approvedNumberTotal", approvedNumberTotal);
                map.put("issueddNumberTotal", issueddNumberTotal);
                map.put("maplist", listMap);
                Workbook workbook = ExcelExportUtil.exportExcel(params, map);

                ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
                workbook.write(outputStream);
                // 处理批示列的纵向合并
                PoiMergeCellUtil.mergeCells(workbook.getSheetAt(0), 2, 0);

                try {
                    response.setCharacterEncoding("UTF-8");
                    response.setHeader("content-Type", "application/vnd.ms-excel");
                    response.setHeader("Content-Disposition", "attachment;filename=" +
                            URLEncoder.encode(month + "月份公文数量统计导出", "UTF-8"));
                    OutputStream ouputStream = response.getOutputStream();
                    workbook.write(ouputStream);
                    ouputStream.flush();
                    ouputStream.close();
                } catch (IOException e) {
                    throw new RuntimeException(e);
                }
            } catch (IOException e) {
                throw new RuntimeException("导出失败！");
            }
        }
    }