如何使用Openpyxl或xlswriter在python中迭代多个工作表以应用格式或更改工作表名称

import openpyxl
from openpyxl.styles import Font

workbook = openpyxl.load_workbook('your_file.xlsx')

for sheet_name in workbook.sheetnames:
    sheet = workbook[sheet_name]
    # 在这里进行你想要的操作

# 示例：将第一行的字体加粗
for sheet_name in workbook.sheetnames:
    sheet = workbook[sheet_name]
    for cell in sheet[1]:
        cell.font = Font(bold=True)

# 示例：将每个工作表的名称前加上前缀"New_"
for sheet_name in workbook.sheetnames:
    sheet = workbook[sheet_name]
    new_sheet_name = "New_" + sheet_name
    workbook[new_sheet_name] = workbook[sheet_name]
    del workbook[sheet_name]

workbook.save('your_modified_file.xlsx')