os pandas代码块
path = input('输入目标文件夹: n')
files = os.listdir(path)
for i in files:
df = pd.read_excel(path + '\{}'.format(i), engine='openpyxl')
a = df.valueas.tolist()
print(a)

os pandas代码块
path = input('输入目标文件夹: n')
files = os.listdir(path)
for i in files:
df = pd.read_excel(path + '\{}'.format(i), engine='openpyxl')
a = df.valueas.tolist()
print(a)