```
import xlwt
import time
def openreadtxt(file_name):
data = []
file = open(file_name,'r',encoding='utf-8') #打开文件
file_data = file.readlines() #读取所有行
print(len(file_data))
for row in file_data:
tmp_list = row.split(' ') #按一个规则切分每行数据
#tmp_list[-1] = tmp_list[-1].replace('\n',',') #去掉换行符
data.append(tmp_list) #将每行数据插入data中
return data
if __name__=="__main__":
data = openreadtxt("时间汇总.txt")
# Preparing: SELECT
data1 = []
data2 = []
time3 = []
#print(data[0][3])
for row in data:
for i in range(len(row)):
if("用时" in row[i]):
str = row[i][row[i].find("----------------")+16:len(row[i])]
data1.append(str[0:str.find("：")])
if("ms" in str[str.find("："):len(str)]):
time3.append(str[str.find("：")+1:str.find("ms")])
else:
time3.append(str[str.find("：")+1:len(str)])
# 设置Excel编码
file = xlwt.Workbook('encoding = utf-8')
# 创建sheet工作表
sheet1 = file.add_sheet('sql',cell_overwrite_ok=True)
#sheet2 = file.add_sheet('time',cell_overwrite_ok=True)
# 先填标题
# sheet1.write(a,b,c) 函数中参数a、b、c分别对应行数、列数、单元格内容
sheet1.write(0, 0, "序号") # 第1行第1列
sheet1.write(0, 1, "内容") # 第1行第2列
sheet1.write(0, 2, "用时")
#sheet2.write(0,0,"序号")
#sheet2.write(0,1,"用时")
# 循环填入数据
num = 0
for i in range(len(data1)):
sheet1.write(i + 1, 0, i)
sheet1.write(i + 1, 1, data1[i])
sheet1.write(i + 1, 2, time3[i])
if(i >= 2):
num += int(time3[i])
sheet1.write(len(data1)+1,0,len(data1)+1)
sheet1.write(len(data1)+1,1,"总计")
sheet1.write(len(data1)+1,2,num)
#for j in range(len(time1)):
# sheet2.write(j+1,0,j)
# sheet2.write(j+1,1,time1[j])
times = time.strftime('%H%M%S',time.localtime(time.time()))
# 保存Excel到.py源文件同级目录
file.save('用时_'+times+'.xls')
print('用时_'+times+'.xls')
print(len(data1))
```