java导出excel 复杂的合并单元格

最新推荐文章于 2024-07-12 13:37:03 发布

魏万燚

最新推荐文章于 2024-07-12 13:37:03 发布

阅读量888

点赞数 1

文章标签： excel java 开发语言

本文链接：https://blog.csdn.net/wwy11123/article/details/129833187

版权

导出excel 复杂的合并单元格

private void exportExcel(List<IuDocStatisticsExcelVo> iuDocStatisticsVos, String startTime, String endTime, HttpServletResponse response) throws UnsupportedEncodingException, ParseException {
        // 设置响应类型
        response.setContentType("application/vnd.ms-excel");
        // 设置字符编码
        response.setCharacterEncoding("utf-8");
        // 设置响应头信息
        response.setHeader("Content-disposition",
                "attachment;filename*=utf-8''" + URLEncoder.encode("皖医互通工作站周报" + "(" + startTime + "-" + endTime + ")", "UTF-8") + ".xlsx");
        // 写入文件
        ExcelWriter writer = ExcelUtil.getWriter();
        // 标题一
        writer.merge(0, 0, 0, 12, "皖医互通工作站每周汇报" + "(" + startTime + "-" + endTime + ")", false);
        // 标题二
        writer.merge(1, 2, 0, 0, "序号", false);
        writer.merge(1, 2, 1, 1, "医院名称", false);
        writer.merge(1, 1, 2, 4, "工作站", false);
        writer.merge(1, 1, 5, 8, "历史提醒", false);
        writer.merge(1, 1, 9, 12, "重复提醒", false);
        writer.passRows(2);
        // 设置高度（行row）
        writer.setRowHeight(0, 50);
        writer.setRowHeight(1, 30);

        writer.setColumnWidth(0, 10);
        writer.setColumnWidth(1, 18);
        writer.setColumnWidth(2, 13);
        writer.setColumnWidth(3, 13);
        writer.setColumnWidth(4, 16);
        writer.setColumnWidth(5, 13);
        writer.setColumnWidth(6, 18);
        writer.setColumnWidth(7, 13);
        writer.setColumnWidth(8, 18);
        writer.setColumnWidth(9, 13);
        writer.setColumnWidth(10, 18);
        writer.setColumnWidth(11, 13);
        writer.setColumnWidth(12, 18);

        // 设置导出信息的表头
        writer.addHeaderAlias("row", "序号");
        writer.addHeaderAlias("hospitalName", "医院名称");

        writer.addHeaderAlias("workstationNum", "工作站数量");
        writer.addHeaderAlias("workActivityRateWeek", "本周活跃率");
        writer.addHeaderAlias("workActivityRateLastWeek", "活跃率较上周比较");

        writer.addHeaderAlias("historyNoticeTimes", "提醒次数");
        writer.addHeaderAlias("historyNoticeRateWeek", "提醒次数较上周比较");
        writer.addHeaderAlias("historyViewNum", "查看次数");
        writer.addHeaderAlias("historyViewRateWeek", "查看次数较上周比较");

        writer.addHeaderAlias("repeatNoticeTimes", "提醒次数 ");
        writer.addHeaderAlias("repeatNoticeRateWeek", "提醒次数较上周比较 ");
        writer.addHeaderAlias("repeatViewNum", "查看次数 ");
        writer.addHeaderAlias("repeatViewRateWeek", "查看次数较上周比较 ");


        // 设置导出表头样式，但不包括合并单元格
        CellStyle headCellStyle = writer.getHeadCellStyle();
        headCellStyle.setFillForegroundColor(IndexedColors.WHITE.getIndex());
        headCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);

        // 写入
        writer.write(iuDocStatisticsVos, true);
        // 主要针对自定义表头设置 行高（必须要写入完成后才可以设置）
        /*for (int i = 2; i < iuDocStatisticsVos.size(); i++) {
            writer.setRowHeight(i, 15);
            writer.setColumnWidth(i, 15);
        }*/
        try {
            writer.flush(response.getOutputStream(), true);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            writer.close();
        }
    }