循环以在多个Excel工作簿中创建多个工作表

import os
from openpyxl import Workbook
from openpyxl.utils import get_column_letter

def create_worksheets_in_workbooks(workbook_dir):
    for filename in os.listdir(workbook_dir):
        if filename.endswith(".xlsx"):
            workbook_path = os.path.join(workbook_dir, filename)
            workbook = Workbook()
            sheet_names = ['Sheet1', 'Sheet2', 'Sheet3']  # 可根据需求自定义工作表名称
            for sheet_name in sheet_names:
                workbook.create_sheet(title=sheet_name)
            workbook.save(workbook_path)
            workbook.close()

# 调用函数并传入Excel工作簿所在的文件夹路径
create_worksheets_in_workbooks('/path/to/workbook/directory')