将单元格的值从多个工作簿复制到主文件

import openpyxl

# 打开主文件和工作簿
main_file = openpyxl.load_workbook('主文件.xlsx')
workbook1 = openpyxl.load_workbook('工作簿1.xlsx')
workbook2 = openpyxl.load_workbook('工作簿2.xlsx')

# 选择目标单元格和来源单元格
main_sheet = main_file['Sheet1']
sheet1 = workbook1['Sheet1']
sheet2 = workbook2['Sheet1']
target_cell = main_sheet['A1']
source_cell1 = sheet1['A1']
source_cell2 = sheet2['A1']

# 复制数值
target_cell.value = source_cell1.value
target_cell.offset(1, 0).value = source_cell2.value

# 保存主文件
main_file.save('主文件.xlsx')