-
Notifications
You must be signed in to change notification settings - Fork 0
/
ConvertToExcel.py
37 lines (34 loc) · 1.21 KB
/
ConvertToExcel.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
from openpyxl import Workbook
write_wb = Workbook()
write_ws = write_wb.active
with open('time_result.txt') as resultFile:
lines = resultFile.readlines()
resultDataList = {}
resultRound = 0
resultLength = 0
resultTime = 0
resultType = ''
for line in lines:
if line[:8] == "[Round: ":
resultRound = int(line[8:-2])
continue
elif line[6:21] == '\'s SP length : ':
resultType = line[0:5]
resultType = resultType.strip()
end = line.find('-')
resultLength = int(line[21:end-1])
start = line.find('Execution time is : ')
start += len('Execution time is : ')
resultTime = float(line[start:-1])
resultDataList[resultType] = [resultLength, resultTime]
elif line[0:1] == '\n':
if len(resultDataList) == 0:
continue
allData = []
for Type in resultDataList.keys():
allData.append(resultDataList[Type][0])
for Type in resultDataList.keys():
allData.append(resultDataList[Type][1])
write_ws.append(allData)
resultDataList.clear()
write_wb.save('test.xlsx')