读取pwrtestlog.log文件

with open('C:/Users/Desktop/pwrtestlog.log', 'r') as f: content = f.readlines()

创建Excel文件

workbook = xlwt.Workbook(encoding='utf-8') worksheet = workbook.add_sheet('Sheet1') worksheet.write(0, 0, 'BiosInitTimeMs') worksheet.write(0, 1, 'DriverWakeTimeMs') worksheet.write(0, 2, 'summation')

匹配关键字并写入Excel

row_index = 1 for line in content: bios_time = re.search('BiosInitTimeMs:(\d+)', line) driver_time = re.search('DriverWakeTimeMs:(\d+)', line) if bios_time: worksheet.write(row_index, 0, int(bios_time.group(1))) if driver_time: worksheet.write(row_index, 1, int(driver_time.group(1))) row_index += 1

计算第三列的值并写入Excel

for i in range(1, row_index): bios_time = worksheet.cell_value(i, 0) driver_time = worksheet.cell_value(i, 1) summation = bios_time + driver_time worksheet.write(i, 2, summation)

保存Excel文件

workbook.save('C:/Users/Desktop/1.xls'

请示例代码：用python完成以下需求：逐行阅读桌面上的pwrtestloglog将文档内BiosInitTimeMs此关键字后跟的数据逐一记录在桌面上创建的1xls的表格的第一列中第一列的列名叫BiosInitTimeMs；将文档内DriverWakeTimeMs此关键字后跟的数据逐一记录在桌面上创建的1xls的表格的第二列中第二列的列名叫DriverWakeTimeMs；将第一列和第二列的数值

原文地址: https://www.cveoy.top/t/topic/g57x 著作权归作者所有。请勿转载和采集!