Python 提取日志数据并生成 Excel 报表

import re/nimport xlwt/n/n# 读取 pwrtestlog.log 文件/nwith open('C:/Users/Desktop/pwrtestlog.log', 'r') as f:/n content = f.readlines()/n/n# 创建 Excel 文件/nworkbook = xlwt.Workbook(encoding='utf-8')/nworksheet = workbook.add_sheet('Sheet1')/nworksheet.write(0, 0, 'BiosInitTimeMs')/nworksheet.write(0, 1, 'DriverWakeTimeMs')/nworksheet.write(0, 2, 'summation')/n/n# 匹配关键字并写入 Excel/nrow_index = 1/nfor line in content:/n bios_time = re.search('BiosInitTimeMs:(/d+)', line)/n driver_time = re.search('DriverWakeTimeMs:(/d+)', line)/n if bios_time:/n worksheet.write(row_index, 0, int(bios_time.group(1)))/n if driver_time:/n worksheet.write(row_index, 1, int(driver_time.group(1)))/n row_index += 1/n/n# 计算第三列的值并写入 Excel/nfor i in range(1, row_index):/n bios_time = worksheet.cell_value(i, 0)/n driver_time = worksheet.cell_value(i, 1)/n summation = bios_time + driver_time/n worksheet.write(i, 2, summation)/n/n# 保存 Excel 文件/nworkbook.save('C:/Users/Desktop/1.xls')