POI 实现Word表格合并单元格（行合并）

旧城等待， 2022-10-07 06:52 743阅读 0赞

### 1 Maven依赖 ###

<dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>easyexcel</artifactId>
                <version>2.2.7</version>
            </dependency>
            <dependency>
                <groupId>cn.hutool</groupId>
                <artifactId>hutool-all</artifactId>
                <version>5.6.2</version>
            </dependency>

### 2 合并单元格 ###

/**
         * 合并单元格
         *
         * @param table         表格对象
         * @param beginRowIndex 开始行索引
         * @param endRowIndex   结束行索引
         * @param colIndex      合并列索引
         */
        public static void mergeCell(XWPFTable table, int beginRowIndex, int endRowIndex, int colIndex) {
            if (beginRowIndex == endRowIndex || beginRowIndex > endRowIndex) {
                return;
            }
            //合并行单元格的第一个单元格
            CTVMerge startMerge = CTVMerge.Factory.newInstance();
            startMerge.setVal(STMerge.RESTART);
            //合并行单元格的第一个单元格之后的单元格
            CTVMerge endMerge = CTVMerge.Factory.newInstance();
            endMerge.setVal(STMerge.CONTINUE);
            table.getRow(beginRowIndex).getCell(colIndex).getCTTc().getTcPr().setVMerge(startMerge);
            for (int i = beginRowIndex + 1; i <= endRowIndex; i++) {
                table.getRow(i).getCell(colIndex).getCTTc().getTcPr().setVMerge(endMerge);
            }
        }

### 3 调试代码 ###

/**
         * 合并单元格
         *
         * @param response
         */
        @GetMapping("/mergeCell")
        public void mergeCell(HttpServletResponse response) {
            try {
                //读文件
                ClassPathResource cpr = new ClassPathResource("/doc/模板合并单元格.docx");
                XWPFDocument document = new XWPFDocument(cpr.getInputStream());
                mergeCell(document.getTableArray(0), 1, 2, 0);
                //返回流
                response.setHeader("content-type", "application/octet-stream");
                response.setContentType("application/octet-stream;charset=UTF-8");
                response.setHeader("Content-Disposition", "attachment; filename=" + new String("模板.docx".getBytes("utf-8"), "ISO-8859-1"));
                OutputStream outputStream = response.getOutputStream();
                document.write(outputStream);
                outputStream.flush();
                outputStream.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

### 4 模板文件 ###

模板路径：

![20210616185021635.png][]

模板内容：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70][]

### 5 调试结果 ###

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 1][]

[20210616185021635.png]: /images/20221005/87fd3ff314634d70b67920126a3e77bc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70]: /images/20221005/fe73a58faa2d4b6897ffef7ab40d42ac.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70 1]: /images/20221005/9c798b81e4fe4d06b33d707cbf514a40.png