用于复制-粘贴Excel文件中的单元格范围的Python脚本

pip install openpyxl

from openpyxl import load_workbook

def copy_paste_range(source_file, destination_file, source_range, destination_range):
    # 打开源文件和目标文件
    source_workbook = load_workbook(source_file)
    destination_workbook = load_workbook(destination_file)

    # 获取源文件和目标文件的工作表
    source_sheet = source_workbook.active
    destination_sheet = destination_workbook.active

    # 复制单元格范围
    for row in source_sheet[source_range]:
        for cell in row:
            destination_sheet[destination_range].cell(row=cell.row, column=cell.column).value = cell.value

    # 保存目标文件
    destination_workbook.save(destination_file)

copy_paste_range("source.xlsx", "destination.xlsx", "A1:B2", "C3")