python 使用glob找到文件后如何打开

Question

根据当前时间匹配匹配到想要的文件了,但是不知道怎么打开

import pandas as pd
import glob
import time
now = time.strftime("%Y%m%d",time.localtime(time.time()))
biao2=glob.glob(r'G:\工作\德宏\实验\MML\MML报文解析'+now+r'*.xlsx')
biao3 = pd.read_excel(biao2)

 

Answer 1

import os
path = 'G:\工作\....省略\文件夹'
for file in biao2:
    biao3 = pd.read_excel(os.path.join(path, file))
    break
print(biao3.head())