将excel工作表另存为单独的文件并遍历文件夹

import os
import openpyxl

def save_worksheets_as_files(folder_path, excel_file):
    # 打开Excel文件
    wb = openpyxl.load_workbook(excel_file)
    
    # 遍历每个工作表
    for sheet_name in wb.sheetnames:
        # 创建一个新的工作簿
        new_wb = openpyxl.Workbook()
        new_ws = new_wb.active
        
        # 复制当前工作表的数据到新的工作簿
        source_ws = wb[sheet_name]
        for row in source_ws.iter_rows():
            for cell in row:
                new_ws[cell.coordinate].value = cell.value
        
        # 保存新的工作簿为单独的文件
        new_file_name = os.path.join(folder_path, f"{sheet_name}.xlsx")
        new_wb.save(new_file_name)
    
    # 关闭Excel文件
    wb.close()

# 遍历指定文件夹下的所有Excel文件
folder_path = "your_folder_path"
for file_name in os.listdir(folder_path):
    if file_name.endswith(".xlsx"):
        excel_file = os.path.join(folder_path, file_name)
        save_worksheets_as_files(folder_path, excel_file)