# -*- coding: utf-8 -*-
import glob
import xlwings as xwx=glob.glob(r'D:\Python实践\测试报告\*.xls*')
if len(x) :
print(x)
for y in x:
wb=xw.Book(y)
sht=wb.sheets[0]
print(sht.range('b2').value,'--->',sht.range('c2').value)
wb.app.quit()
else:
print('no related files')