练习：从txt文档读取关键数据，并写入excel

从txt文档读取关键数据，并写入excel

import xlwt

with open('C:\\Users\\ThinkPad\\Desktop\\test3.log', 'w+', encoding='utf-8') as f:
    for text in f.readlines():
        data = text.split("\n", 2)
        if "提取特征值,需要" in data[0]:
            new_data = data[0].split("需要")
            a = new_data[1].split("毫秒")[0]
            f.write(a+",")
        if "特征值比对,需要" in data[0]:
            new_data1 = data[0].split("需要")
            a = new_data1[1].split("毫秒")[0]
            f.write(a + ",")
        if "整个查找时间需要" in data[0]:
            new_data2 = data[0].split("需要")
            a = new_data2[1].split("毫秒")[0]
            f.write(a + "\n")
    f.save()
    book = xlwt.Workbook()
    sheet = book.add_sheet('test12', cell_overwrite_ok=True)
    title = ['提取特征值,需要', '特征值比对,需要', '整个查找时间需要']
    for i in range(0, 3):
        sheet.write(0, i, title[i])
    row = 1
    col = 0
    for lines in f:
        list1 = lines.split(',')
        for i in range(len(list1)):
            sheet.write(row, col, list1[i])
            col += 1
        row += 1
        col = 0
    book.save('bug记录2.xls')