auto generate result exel
from openpyxl import Workbook
def openFile(filename):
newlines = []
with open(filename) as file:
lines = file.readlines()
count = 0
for line in lines:
if count <= 4:
count += 1
continue
elif count >= 48:
break
else:
newline = line.rstrip('\n').split('\t')
newlines.append(newline)
count += 1
return newlines;
# nums--total of machines,sn--index of machine(start 1),newlines--currnte file information
def writeExcel(nums, sn, newlines,ws):
start = sn + 1
i = 1
for element in newlines:
ws.cell(row=i,column=1,value=element[0])
ws.cell(row=i, column=start, value=element[1])
ws.cell(row=i, column=start + nums + 2, value=element[2])
ws.cell(row=i, column=start + (nums + 2) * 2, value=element[3])
i += 1
return;
wb = Workbook()
nums=2
probeList=["F2_5c","F4_12L","G1_4P"]
Listfiles = ["myperformanceF2_5C.txt", "oldperformanceF2_5C.txt","myperformanceF4_12L.txt", "oldperformanceF4_12L.txt","myperformanceG1_4P.txt","oldperformanceG1_4P.txt"]
openList = []
for i in Listfiles:
openList.append(openFile(i))
# j--index of current machine
j = 1
#probe index
probeIndex,product=1,0
for probe in probeList:
ws=wb.create_sheet(probe)
for i in range(1,nums+1):
writeExcel(nums,i,openList[product],ws)
product+=1
#write title
wb.save("sample.xlsx")
