import openpyxl import os from datetime import datetime

定义文件路径和文件名

file_path = 'example.xlsx' file_name = os.path.splitext(file_path)[0]

创建拆分结果文件夹

folder_name = '拆分结果' desktop_path = os.path.join(os.path.expanduser('~'), 'Desktop') folder_path = os.path.join(desktop_path, folder_name) if not os.path.exists(folder_path): os.mkdir(folder_path)

打开Excel文件

workbook = openpyxl.load_workbook(file_path)

获取所有工作表

sheets = workbook.sheetnames

排除第一个工作表

sheets = sheets[1:]

遍历每个工作表，拆分为单独的Excel文件

for sheet_name in sheets: # 创建新的Excel文件 new_workbook = openpyxl.Workbook() new_workbook.remove(new_workbook.active) new_sheet = new_workbook.create_sheet(sheet_name)

# 复制数据
sheet = workbook[sheet_name]
for row in sheet.iter_rows():
    for cell in row:
        new_sheet[cell.coordinate].value = cell.value

# 保存新的Excel文件
date_str = datetime.now().strftime('%Y%m%d')
new_file_name = f'{sheet_name}-{date_str}.xlsx'
new_file_path = os.path.join(folder_path, new_file_name)
new_workbook.save(new_file_path)

关闭Excel文件

workbook.close()