python打开最新的excel文件

import os
import glob
import pandas as pd

def get_latest_excel_file():
    # 指定文件夹路径
    folder_path = 'path/to/excel/files'
    
    # 获取文件夹中所有Excel文件的路径
    excel_files = glob.glob(os.path.join(folder_path, '*.xlsx'))
    
    # 根据文件的修改时间进行排序
    latest_excel_file = max(excel_files, key=os.path.getmtime)
    
    return latest_excel_file

latest_file = get_latest_excel_file()
df = pd.read_excel(latest_file)