可以使用Python的openpyxl库来实现这个功能,示例代码如下:
from openpyxl import load_workbook
source = load_workbook(filename='source.xlsx') target = load_workbook(filename='target.xlsx')
for sheet_name in source.sheetnames: source_sheet = source[sheet_name] target_sheet = target.create_sheet(title=sheet_name)