操作:通过正则表达式,匹配到需要的字段,分别写入excel中
# -*- coding: utf-8 -*
import requests
import re
import pymysql
import xlwt
import xlrd
from xlutils.copy import copy
#打开本地文件
with open('G:\PythonWorkSpace\XiechengHotel\session.log', 'r') as f:
data = f.read()
print data
patternStart = re.compile('FUNC]starttime:(.*?),reqID:(.*?)=', re.S)
#去掉所有空格
datarep = data.replace(' ', '').replace('\r', '').replace('\n', '').replace('\t', '')
print datarep
#匹配
resultStart = re.findall(patternStart, datarep)
i = 0
filename = 'G:\PythonWorkSpace\XiechengHotel\T3.xls' # 文件名
rb = xlrd.open_workbook(filename)
wb = copy(rb) # 复制页面
ws = wb.get_sheet(0) # 取第一个sheet
for item in resultStart:
i = i+1
print "---------------Start item:"+ str(i)+ "--------------"
print item[0], item[1]
ws.write(i,2, item[0]) #写入i行3列
ws.write(i, 0, item[1]) #写入i行1列
wb.save(filename) # 保存文件
print(f.closed)