import openpyxl import os from datetime import datetime

打开Excel文件

wb = openpyxl.load_workbook('example.xlsx')

获取所有工作表

sheets = wb.sheetnames

排除第一个工作表

sheets.pop(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)

遍历每个工作表

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

# 复制工作表内容到新的Excel文件
sheet = wb[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')
file_name = f'{sheet_name}-{date_str}.xlsx'
file_path = os.path.join(folder_path, file_name)
new_wb.save(file_path)

# 关闭新的Excel文件
new_wb.close()

关闭原Excel文件

wb.close(