遍历文件夹Excel path添加列表中

	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()

#遍历一个文件夹---->二级文件夹下的使用文件--->添加到列表