Python学习笔记之--实验室燃烧分析仪vie数据提取---生成excel文件

# -*- coding: utf-8 -*-
import os
import xlwt
input("Please click enter to start !")
print("Please wait ...")

path=os.getcwd()+'\\'
Excel=xlwt.Workbook(encoding='utf-8')
table=Excel.add_sheet("vie")
row,col=0,0

for filename in os.listdir(path):
    if os.path.splitext(filename)[1] == ".vie":
        table.write(row,0,filename)
        row=row+1
        f = open(path+filename)
        contents=f.readlines()
        for i in range(len(contents)):
            if "[list table]" in contents[i]:
                BeganRow=i
                for j in range(i,len(contents)):
                    if contents[j] == '\n':
                        EndRow=j
                        break
        print(BeganRow,EndRow)
        for i in range(BeganRow,EndRow,1):
            if "C.A. of Pmax" in contents[i]:
                BeganRow1=i
                for j in range(BeganRow1,EndRow):
                    if "Ignition timing" in contents[j]:
                        EndRow1=j
                        break
        print(BeganRow1,EndRow1)
        for i in range(BeganRow1,EndRow1):
            print(contents[i])
            strlist=contents[i].split(',')
            table.write(row,1,strlist[1])
            table.write(row,2,strlist[2])
            row=row+1
            pass

        for i in range(EndRow1,EndRow,1):
            if "C.A. of dQmax" in contents[i]:
                BeganRow2=i
                for j in range(BeganRow2,EndRow):
                    if "UMEP" in contents[j]:
                        EndRow2=j
                        break
        print(BeganRow2,EndRow2)
        for i in range(BeganRow2,EndRow2,1):
            strlist=contents[i].split(',')
            strlist = contents[i].split(',')
            table.write(row, 1, strlist[1])
            table.write(row, 2, strlist[2])
            row = row + 1
            pass

        for i in range(EndRow2,EndRow,1):
            if "Effective COV" in contents[i]:
                BeganRow3=i
                for j in range(BeganRow2,EndRow):
                    if "LNV" in contents[j]:
                        EndRow3=j
                        break
        for i in range(BeganRow3,EndRow3):
            print(contents[i])
            strlist=contents[i].split(',')
            strlist = contents[i].split(',')
            table.write(row, 1, strlist[1])
            table.write(row, 2, strlist[2])
            row = row + 1
Excel.save(path+'vie.xls')
print("The work has been completed !")