import os,re import openpyxl #读取目录下的所有txt文件 wb = openpyxl.Workbook() sheet = wb.active filePath = 'E:\\04.AutomationProject\\PracticePython\\' pathDir = os.walk(filePath) i=1 for root, subFolders, fileNames in pathDir: for fileName in fileNames: mo = re.compile(r'.*\.txt$').search(fileName) if mo == None: continue else: newDir = os.path.join(root, mo.group())#拼接txt的完整路径 fp = open(newDir, 'r', errors='ignore') lines = fp.readlines() for line in lines: sheet['A'+str(i)].value=line i = i + 1 wb.save("1.xlsx") print("Done") wb.close()
第12章 将某目录下所有文本读取到Excel中
最新推荐文章于 2023-07-06 21:18:30 发布