1 from xlwt import * 2 import os 3 #------------------读数据--------------------------------- 4 #判断是否存在有此类型的文件且文件名一致 5 #---mrs_vgw--- 6 fileName_mrs_vgw_3 = "ubp_mrs_vgw日志error扫描结果.txt" 7 fileName_mrs_vgw_2 = "mrs_vgw日志摄像头注册记录.txt" 8 fileName_mrs_vgw_1 = "mrs_vgw进程CPU和内存使用率文件.txt" 9 #---mrs_rec_man--- 10 fileName_mrs_rec_man_1 = "mrs_rec_man进程CPU和内存使用率文件.txt" 11 fileName_mrs_rec_man_2 = "ubp_mrs_rec_man日志error扫描结果.txt" 12 fileName_mrs_rec_man_3 = "ubp_mrs_rec_man日志扫描结果.txt" 13 #---mrs_rec_sinker--- 14 fileName_mrs_rec_sinker_1 = "mrs_rec_sinker进程CPU和内存使用率文件.txt" 15 fileName_mrs_rec_sinker_2 = "ubp_mrs_rec_sinker日志error扫描结果.txt" 16 fileName_mrs_rec_sinker_3 = "ubp_mrs_rec_sinker日志扫描结果.txt" 17 #---文件名字列表--- 18 filenames = []#创建空列表的名字集合 19 filenames.append(fileName_mrs_vgw_1) 20 filenames.append(fileName_mrs_vgw_2) 21 filenames.append(fileName_mrs_vgw_3) 22 filenames.append(fileName_mrs_rec_sinker_1) 23 filenames.append(fileName_mrs_rec_sinker_2) 24 filenames.append(fileName_mrs_rec_sinker_3) 25 filenames.append(fileName_mrs_rec_man_1) 26 filenames.append(fileName_mrs_rec_man_2) 27 filenames.append(fileName_mrs_rec_man_3) 28 29 data_list = []#汇总数据列表 30 31 for name in filenames: 32 filePath = "D:日志巡检存放路径" 33 os.chdir(filePath) 34 path = os.getcwd() 35 if os.path.exists(name): 36 file_only_open = open(name, "r") 37 if name == fileName_mrs_rec_man_1: 38 lines = file_only_open.readlines() 39 data_list.append(fileName_mrs_rec_man_1.strip("文件.txt") + ':' + ' ') 40 for line in lines: 41 data_list.append(line) 42 data_list.append(' ') 43 if name == fileName_mrs_rec_sinker_1: 44 lines = file_only_open.readlines() 45 data_list.append(fileName_mrs_rec_sinker_1.strip("文件.txt") + ':' + ' ') 46 for line in lines: 47 data_list.append(line) 48 data_list.append(' ') 49 if name == fileName_mrs_vgw_1: 50 lines = file_only_open.readlines() 51 data_list.append(fileName_mrs_vgw_1.strip("文件.txt") + ':' + ' ') 52 for line in lines: 53 data_list.append(line) 54 data_list.append(' ') 55 if name == fileName_mrs_rec_man_3: 56 lines = file_only_open.readlines() 57 data_list.append(fileName_mrs_rec_man_3.strip("文件.txt") + ':' + ' ') 58 for line in lines: 59 data_list.append(line) 60 data_list.append(' ') 61 else: 62 print("没有找到此文件:" + name) 63 64 # 文件读写方式是追加 65 file_new = open("MRS巡检报告手填数据汇总.txt", "w+") 66 for data in data_list: 67 file_new.writelines(str(data)) 68 file_new.close()