如何使用python遍历多个excel文件

import openpyxl

excel_files = []

import os
folder_path = "文件夹路径"
files = os.listdir(folder_path)

for file in files:
    if file.endswith(".xlsx") or file.endswith(".xls"):
        excel_files.append(os.path.join(folder_path, file))

for file_path in excel_files:
    workbook = openpyxl.load_workbook(file_path)
    # 处理Excel文件的代码

import openpyxl
import os

folder_path = "文件夹路径"
excel_files = []

files = os.listdir(folder_path)

for file in files:
    if file.endswith(".xlsx") or file.endswith(".xls"):
        excel_files.append(os.path.join(folder_path, file))

for file_path in excel_files:
    workbook = openpyxl.load_workbook(file_path)
    # 处理Excel文件的代码
    sheet_names = workbook.sheetnames
    for sheet_name in sheet_names:
        sheet = workbook[sheet_name]
        max_row = sheet.max_row
        max_column = sheet.max_column
        for row in range(1, max_row+1):
            for column in range(1, max_column+1):
                cell_value = sheet.cell(row=row, column=column).value
                # 处理单元格的值

pip install openpyxl