java复制excel表行

你可以使用Apache POI库来复制Excel表的行。下面是一个示例代码，可以帮助你完成这个任务：

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.util.CellRangeAddress;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;

public class ExcelRowCopyExample {
    public static void main(String[] args) {
        String sourceFile = "source.xlsx";
        String destinationFile = "destination.xlsx";
        int sourceSheetIndex = 0;
        int destinationSheetIndex = 1;
        int sourceRowIndex = 0; // 源行索引，从0开始计数
        int destinationRowIndex = 2; // 目标行索引，从0开始计数

        try (FileInputStream fis = new FileInputStream(sourceFile);
             Workbook sourceWorkbook = new XSSFWorkbook(fis);
             FileOutputStream fos = new FileOutputStream(destinationFile);
             Workbook destinationWorkbook = new XSSFWorkbook()) {

            Sheet sourceSheet = sourceWorkbook.getSheetAt(sourceSheetIndex);
            Sheet destinationSheet = destinationWorkbook.createSheet();
            
            Row sourceRow = sourceSheet.getRow(sourceRowIndex);
            Row destinationRow = destinationSheet.createRow(destinationRowIndex);

            // 复制源行的样式
            copyRowStyle(sourceRow, destinationRow);

            // 复制源行的单元格内容
            copyRowCells(sourceRow, destinationRow);

            // 复制合并单元格
            copyMergedRegions(sourceSheet, destinationSheet, sourceRowIndex, destinationRowIndex);

            // 保存目标文件
            destinationWorkbook.write(fos);
            System.out.println("行复制成功！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    private static void copyRowStyle(Row sourceRow, Row destinationRow) {
        destinationRow.setHeight(sourceRow.getHeight());
        for (int i = 0; i < sourceRow.getLastCellNum(); i++) {
            Cell sourceCell = sourceRow.getCell(i);
            Cell destinationCell = destinationRow.createCell(i);
            destinationCell.setCellStyle(sourceCell.getCellStyle());
        }
    }

    private static void copyRowCells(Row sourceRow, Row destinationRow) {
        for (int i = 0; i < sourceRow.getLastCellNum(); i++) {
            Cell sourceCell = sourceRow.getCell(i);
            Cell destinationCell = destinationRow.createCell(i);
            if (sourceCell != null) {
                switch (sourceCell.getCellType()) {
                    case STRING:
                        destinationCell.setCellValue(sourceCell.getStringCellValue());
                        break;
                    case NUMERIC:
                        destinationCell.setCellValue(sourceCell.getNumericCellValue());
                        break;
                    case BOOLEAN:
                        destinationCell.setCellValue(sourceCell.getBooleanCellValue());
                        break;
                    case FORMULA:
                        destinationCell.setCellFormula(sourceCell.getCellFormula());
                        break;
                    default:
                        destinationCell.setCellValue("");
                }
            }
        }
    }

    private static void copyMergedRegions(Sheet sourceSheet, Sheet destinationSheet, int sourceRowIndex, int destinationRowIndex) {
        for (CellRangeAddress mergedRegion : sourceSheet.getMergedRegions()) {
            if (mergedRegion.getFirstRow() <= sourceRowIndex && mergedRegion.getLastRow() >= sourceRowIndex) {
                int firstColumn = mergedRegion.getFirstColumn();
                int lastColumn = mergedRegion.getLastColumn();
                int newFirstRow = mergedRegion.getFirstRow() + destinationRowIndex - sourceRowIndex;
                int newLastRow = mergedRegion.getLastRow() + destinationRowIndex - sourceRowIndex;
                CellRangeAddress newMergedRegion = new CellRangeAddress(newFirstRow, newLastRow, firstColumn, lastColumn);
                destinationSheet.addMergedRegion(newMergedRegion);
            }
        }
    }
}

上述代码使用了Apache POI库来实现Excel行的复制。你需要将源文件名、目标文件名、源表索引、目标表索引、源行索引和目标行索引等信息替换成你自己的实际情况。请确保在运行代码之前已经将Apache POI库添加到你的项目中。

希望能帮到你！如果有任何问题，请随时提问。