for root, dirs, files in os.walk(dir):
for file in files:
lj= os.path.join(root,file)
wb = vb.load_workbook(lj)
gzb = wb.active
list = []
for data in gzb[3]:
if data.value != None:
list.append(data.value)
print(list)
每个文件大概就十行数据,我大概就想要3-10行的数据,有什么好方法能解决吗?