在Python中将excel工作表从一个工作表复制到另一个工作表

pip install openpyxl

from openpyxl import load_workbook

# 打开源Excel文件
source_file = load_workbook('source.xlsx')
# 打开目标Excel文件
target_file = load_workbook('target.xlsx')

# 选择源工作表
source_sheet = source_file['Sheet1']
# 选择目标工作表
target_sheet = target_file['Sheet1']

for row in source_sheet.iter_rows():
    for cell in row:
        # 复制单元格的值和格式
        target_sheet[cell.coordinate].value = cell.value
        target_sheet[cell.coordinate].font = cell.font
        target_sheet[cell.coordinate].fill = cell.fill
        target_sheet[cell.coordinate].border = cell.border
        target_sheet[cell.coordinate].alignment = cell.alignment
        target_sheet[cell.coordinate].number_format = cell.number_format

target_file.save('target.xlsx')