Python + Win32:将页眉从一个Excel工作簿粘贴到另一个工作簿的顶部

pip install pywin32

import win32com.client as win32

# 打开源工作簿
source_workbook = win32.gencache.EnsureDispatch('Excel.Application')
source_workbook.Visible = False
source_workbook.DisplayAlerts = False
source_workbook_file = r'path_to_source_workbook.xlsx'
source_workbook.Open(source_workbook_file)

# 获取源工作簿的页眉内容
source_header = source_workbook.ActiveSheet.PageSetup.CenterHeader

# 打开目标工作簿
target_workbook = win32.gencache.EnsureDispatch('Excel.Application')
target_workbook.Visible = False
target_workbook.DisplayAlerts = False
target_workbook_file = r'path_to_target_workbook.xlsx'
target_workbook.Open(target_workbook_file)

# 将页眉粘贴到目标工作簿的顶部
target_workbook.ActiveSheet.PageSetup.CenterHeader = source_header

# 保存目标工作簿并关闭工作簿
target_workbook.Save()
target_workbook.Close()

# 关闭源工作簿
source_workbook.Close()