将PivotTable范围从一个工作表复制到另一个工作表。代码正在复制活动工作表数据

import openpyxl

# 打开源工作簿
source_workbook = openpyxl.load_workbook('source.xlsx')
source_sheet = source_workbook['Sheet1']

# 打开目标工作簿
target_workbook = openpyxl.load_workbook('target.xlsx')
target_sheet = target_workbook['Sheet1']

# 复制PivotTable范围
pivot_range = source_sheet['A1:D10']
target_sheet['A1'].value = pivot_range

# 保存目标工作簿
target_workbook.save('target.xlsx')

import org.apache.poi.ss.usermodel.*;

public class PivotTableCopy {
    public static void main(String[] args) throws Exception {
        // 打开源工作簿
        Workbook sourceWorkbook = WorkbookFactory.create(new File("source.xlsx"));
        Sheet sourceSheet = sourceWorkbook.getSheet("Sheet1");

        // 打开目标工作簿
        Workbook targetWorkbook = WorkbookFactory.create(new File("target.xlsx"));
        Sheet targetSheet = targetWorkbook.getSheet("Sheet1");

        // 复制PivotTable范围
        CellRangeAddress pivotRange = CellRangeAddress.valueOf("A1:D10");
        for (int row = pivotRange.getFirstRow(); row <= pivotRange.getLastRow(); row++) {
            for (int col = pivotRange.getFirstColumn(); col <= pivotRange.getLastColumn(); col++) {
                Row sourceRow = sourceSheet.getRow(row);
                Cell sourceCell = sourceRow.getCell(col);

                Row targetRow = targetSheet.getRow(row);
                if (targetRow == null) {
                    targetRow = targetSheet.createRow(row);
                }
                Cell targetCell = targetRow.createCell(col);
                targetCell.setCellValue(sourceCell.getStringCellValue());
            }
        }

        // 保存目标工作簿
        try (OutputStream outputStream = new FileOutputStream("target.xlsx")) {
            targetWorkbook.write(outputStream);
        }
    }
}