读取python文件夹中的子文件夹中的excel文件

import os
import glob
import pandas as pd

def read_excel_files(folder_path):
    excel_files = []
    for root, dirs, files in os.walk(folder_path):
        for file in files:
            if file.endswith(".xlsx") or file.endswith(".xls"):
                excel_files.append(os.path.join(root, file))
    return excel_files

folder_path = "your_folder_path"
excel_files = read_excel_files(folder_path)