import xlsxwriter
import os
class FilePath():
def __init__(self, suffix,path):
self.list_all = []
self.dir_path = path
self.suffix = suffix
def foldername(self,dir_path):
a = dir_path.split('\\')
return a[len(a) - 1]
def run(self):
name1 = self.foldername(self.dir_path)
number_2 = 0
# 创建xlsx
excel_path = self.dir_path + "\\" + name1.split('-')[0] + ".xlsx"
insterment = name1.split('-')[0] # 文件名
workbook = xlsxwriter.Workbook(excel_path)
lte_class = os.listdir(self.dir_path)
for class_item in lte_class:
name2 = class_item
class_item_path = os.path.join(self.dir_path, class_item)
# print(class_item_path)
if not os.path.isdir(class_item_path): # 判断Agilent中的内容是否为文件夹,不是则进入下一循环
continue
else:
if not os.listdir(class_item_path): # 若是文件夹,则判断里面内容是否为空,为空则进入下一文件夹
continue
else:
if name2: # 若进入RRM的子文件夹,则创建一个RRM的子表
# worksheet = workbook.add_worksheet('RRM')
lte_ss = os.listdir(class_item_path)
workbook.close()
for ss_item in lte_ss:
name3 = ss_item
ss_path = os.path.join(class_item_path, ss_item)
if not os.listdir(ss_path): # RRM文件夹中子文件夹为空则进入下一文件夹
continue
else:
file_ss = os.listdir(ss_path)
for file_item in file_ss:
file_path = os.path.join(ss_path, file_item)
ext = os.path.splitext(file_path)
if ext[1] == '.'+self.suffix: # 只读取.xlsx文件
word_file_path = file_path.replace("\\", "/")
self.list_all.append(word_file_path)
return self.list_all
if __name__ == '__main__':
path = r"C:\Users\\Desktop\Q111"
D = Dir_Path(path ,"xlsx")
D.run()
#遍历一个文件夹---->二级文件夹下的使用文件--->添加到列表
遍历文件夹Excel path添加列表中
最新推荐文章于 2023-11-28 12:04:04 发布