如何在python中为excel表格的整个文件夹创建编辑循环？

import os
from openpyxl import load_workbook

folder_path = "your_folder_path"

for filename in os.listdir(folder_path):
    if filename.endswith(".xlsx") or filename.endswith(".xls"):
        file_path = os.path.join(folder_path, filename)
        # 执行相应的操作

workbook = load_workbook(file_path)

worksheet = workbook.active

cell_value = worksheet.cell(row=row_number, column=column_number).value
worksheet.cell(row=row_number, column=column_number).value = new_value

workbook.save(file_path)

import os
from openpyxl import load_workbook

folder_path = "your_folder_path"

for filename in os.listdir(folder_path):
    if filename.endswith(".xlsx") or filename.endswith(".xls"):
        file_path = os.path.join(folder_path, filename)
        
        workbook = load_workbook(file_path)
        worksheet = workbook.active
        
        # 执行相应的操作
        
        workbook.save(file_path)