python将txt⽂件变为excel⽂件（逐行写入）

 代码如下：

import xlwt
txtname ='label.txt'
excelname ='label.xlsx'
fopen =open(txtname,'r')
lines = fopen.readlines()
file = xlwt.Workbook(encoding='utf-8', style_compression=0)

sheet = file.add_sheet('data')        # 新建⼀个sheet
i =0
for line in lines:
    line = line.strip('\n')
    line = line.split(' ')
    picName = line[0]
    x1 = line[1]
    y1 = line[2]
    x2 = line[3]
    y2 = line[4]
    className=line[5]
    sheet.write(i,0, picName)
    sheet.write(i,1, x1)
    sheet.write(i,2, y1)
    sheet.write(i,3, x2)
    sheet.write(i,4, y2)
    sheet.write(i,5, className)
    i = i +1
file.save(excelname