如何在python中导入顺序列表中的所有excel文件？

pip install pandas

import os
import pandas as pd

def get_excel_files(folder_path):
    excel_files = []
    for file in os.listdir(folder_path):
        if file.endswith(".xlsx") or file.endswith(".xls"):
            excel_files.append(os.path.join(folder_path, file))
    return excel_files

def import_excel_files(excel_files):
    data_frames = []
    for file in excel_files:
        data_frames.append(pd.read_excel(file))
    merged_data = pd.concat(data_frames)
    return merged_data

folder_path = "文件夹路径"
excel_files = get_excel_files(folder_path)
merged_data = import_excel_files(excel_files)