POI Word表格复制行2种方式（copy()、手动复制行）

谁践踏了优雅 2023-01-17 03:24 625阅读 0赞

## 1 pom.xml(Maven依赖文件) ##

<dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi</artifactId>
                <version>3.17</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml</artifactId>
                <version>3.17</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml-schemas</artifactId>
                <version>3.17</version>
            </dependency>

## 2 copy()（第一种方法） ##

### 2.1 调试代码 ###

/**
         * 复制行
         */
        @GetMapping("/copyRow1")
        public void copyRow1(HttpServletResponse response) {
            String templateFileName = "D:/test/模板.docx";
            try {
                InputStream inputStream = new FileInputStream(templateFileName);
                XWPFDocument document = new XWPFDocument(inputStream);
                XWPFTable table = document.getTableArray(0);
                XWPFTableRow twoRow = table.getRow(1);
                //将第二行复制到第三行
                XmlObject copy = twoRow.getCtRow().copy();
                table.addRow(new XWPFTableRow((CTRow) copy, table));
                twoRow.getCell(0).setText("第二行");
                //获取复制的第三行
                XWPFTableRow threeRow = table.getRow(2);
                threeRow.getCell(0).setText("第三行");
                //保存文件
                String fileName="模板.docx";
                response.setHeader("content-type", "application/octet-stream");
                response.setContentType("application/octet-stream;charset=UTF-8");
                response.setHeader("Content-Disposition", "attachment; filename=" + new String(fileName.getBytes("utf-8"),"ISO-8859-1"));
                OutputStream outputStream=response.getOutputStream();
                document.write(outputStream);
                outputStream.flush();
                outputStream.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

### 2.2 调试结果 ###

![20210426214153961.png][]

## 3 手动复制行（第二种方法推荐） ##

### 3.1 调试代码 ###

/**
         * 复制行
         */
        @GetMapping("/copyRow2")
        public void copyRow2(HttpServletResponse response) {
            String templateFileName = "D:/test/模板.docx";
            try {
                InputStream inputStream = new FileInputStream(templateFileName);
                XWPFDocument document = new XWPFDocument(inputStream);
                XWPFTable table = document.getTableArray(0);
                XWPFTableRow twoRow = table.getRow(1);
                twoRow.getCell(0).setText("第二行");
                //创建第三行
                XWPFTableRow threeRow = table.insertNewTableRow(2);
                //将第二行复制到第三行
                createCellsAndCopyStyles(threeRow, twoRow);
                threeRow.getCell(0).setText("第三行");
                //保存文件
                String fileName = "模板.docx";
                response.setHeader("content-type", "application/octet-stream");
                response.setContentType("application/octet-stream;charset=UTF-8");
                response.setHeader("Content-Disposition", "attachment; filename=" + new String(fileName.getBytes("utf-8"), "ISO-8859-1"));
                OutputStream outputStream = response.getOutputStream();
                document.write(outputStream);
                outputStream.flush();
                outputStream.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
        /**
         * 复制单元格和样式
         *
         * @param targetRow 要复制的行
         * @param sourceRow 被复制的行
         */
        public static void createCellsAndCopyStyles(XWPFTableRow targetRow, XWPFTableRow sourceRow) {
            targetRow.getCtRow().setTrPr(sourceRow.getCtRow().getTrPr());
    
            List<XWPFTableCell> tableCells = sourceRow.getTableCells();
    
            if (CollectionUtils.isEmpty(tableCells)) {
                return;
    
            }
    
            for (XWPFTableCell sourceCell : tableCells) {
                XWPFTableCell newCell = targetRow.addNewTableCell();
    
                newCell.getCTTc().setTcPr(sourceCell.getCTTc().getTcPr());
    
                List sourceParagraphs = sourceCell.getParagraphs();
    
                if (CollectionUtils.isEmpty(sourceParagraphs)) {
                    continue;
    
                }
    
                XWPFParagraph sourceParagraph = (XWPFParagraph) sourceParagraphs.get(0);
    
                List targetParagraphs = newCell.getParagraphs();
    
                if (CollectionUtils.isEmpty(targetParagraphs)) {
                    XWPFParagraph p = newCell.addParagraph();
    
                    p.getCTP().setPPr(sourceParagraph.getCTP().getPPr());
    
                    XWPFRun run = p.getRuns().isEmpty() ? p.createRun() : p.getRuns().get(0);
    
                    run.setFontFamily(sourceParagraph.getRuns().get(0).getFontFamily());
    
                } else {
                    XWPFParagraph p = (XWPFParagraph) targetParagraphs.get(0);
    
                    p.getCTP().setPPr(sourceParagraph.getCTP().getPPr());
    
                    XWPFRun run = p.getRuns().isEmpty() ? p.createRun() : p.getRuns().get(0);
                    if (sourceParagraph.getRuns().size() > 0) {
                        run.setFontFamily(sourceParagraph.getRuns().get(0).getFontFamily());
                    }
                }
            }
        }

### 3.2 调试结果 ###

![20210426215546902.png][]

## 4 注意事项 ##

第一种方法使用copy()复制的单元格无法写入内容，推荐使用第二种方法手动复制行。

[20210426214153961.png]: /images/20221022/bbf61d757c7345808d60b7c8381f1d7c.png
[20210426215546902.png]: /images/20221022/3ab62c34d6eb4c779964227e04723590.png