将文件夹中的所有工作表重命名为相同的名称

import os
from openpyxl import load_workbook

def rename_worksheets(folder_path, new_name):
    for file in os.listdir(folder_path):
        if file.endswith(".xlsx") or file.endswith(".xlsm"):
            file_path = os.path.join(folder_path, file)
            wb = load_workbook(file_path)
            for sheet in wb.sheetnames:
                wb[sheet].title = new_name
            wb.save(file_path)
            wb.close()

# 示例用法
folder_path = "文件夹路径"
new_name = "新的工作表名称"
rename_worksheets(folder_path, new_name)