Skip to main content
 首页 » 编程设计

python之如何在 python 中将 .txt 转换为 .xls

2025年05月04日9grandyang

with open(output_filename, 'w') as f_output: 
    for dirpath, dirnames, filenames in os.walk(directory):  
        for filename in filenames: 
             if filename.startswith('VCALogParser_output'):  
                cur_file = os.path.join(dirpath, filename) 
                with open(cur_file, "r") as f_input: 
                    f_input.seek(0, os.SEEK_END) 
                    backup = min(back_up , f_input.tell()) 
                    f_input.seek(-backup, os.SEEK_END) 
                    last_lines = ''.join(f_input.readlines()[-6:]) 
                    try: 
                        summary = ', '.join(re.search(r'(\d+ warning\(s\)).*?(\d+ error\(s\)).*?(\d+ scenarios\(s\) FAILED)', last_lines, re.S).groups()) 
                    except AttributeError: 
                        summary = "VCA DID NOT START" 
                    f_output.write('{}: {}\n'.format(filename, summary)) 

上面的代码正在解析一个文件并从文件中读取一些数据并将其作为 .txt 格式的输出。但我想将其输出为 .xls。谁能告诉我如何将下面的 .txt 转换为 .xls?

以 .txt 形式输出:

VCALogParser_output_ARW.log: 12 warning(s), 85 error(s), 32 scenarios(s) FAILED 
VCALogParser_output_CZC.log: 18 warning(s), 33 error(s), 14 scenarios(s) FAILED 
VCALogParser_output_DUN.log: VCA DID NOT START 
VCALogParser_output_FRC.log: 12 warning(s), 34 error(s), 12 scenarios(s) FAILED 
VCALogParser_output_GED.log: 39 warning(s), 79 error(s), 27 scenarios(s) FAILED 
VCALogParser_output_MNT.log: 41 warning(s), 76 error(s), 33 scenarios(s) FAILED 
VCALogParser_output_NON.log: 25 warning(s), 50 error(s), 14 scenarios(s) FAILED 
VCALogParser_output_PTB.log: VCA DID NOT START 
VCALogParser_output_PTP.log: 31 warning(s), 35 error(s), 21 scenarios(s) FAILED 
VCALogParser_output_SPM.log: 58 warning(s), 150 error(s), 57 scenarios(s) FAILED 
VCALogParser_output_SWS.log: 14 warning(s), 23 error(s), 11 scenarios(s) FAILED 

请您参考如下方法:

尝试 xlutils模块

“处理需要 xlrd 和 xlwt 的 Excel 文件的实用程序”