python将txt转换为xls

import xlwt
txtname = 'C:/Users/小翟/Desktop/shuju.txt'
excelname = 'C:/Users/小翟/Desktop/北京数据.xlsx'
 
fopen = open('C:/Users/小翟/Desktop/shuju.txt', 'rb')
lines = fopen.readlines()
 
 
file = xlwt.Workbook(encoding='utf-8', style_compression=0)
#新建一个sheet
sheet = file.add_sheet('data')
 
i = 0
for line in lines:
    line = line.decode().strip('\n')
    line = line.split(',')
    company_num = line[0]
    date = line[1]
    baifenbi = line[2]
    print(line)
    sheet.write(i, 0, company_num)
    sheet.write(i, 1, date)
    sheet.write(i, 2, baifenbi)
    sheet.write(i, 3, line[3])
    sheet.write(i, 4, line[4])
    sheet.write(i, 5, line[5])
    sheet.write(i, 6, line[6])
    sheet.write(i, 7, line[7])
    sheet.write(i, 8, line[8])
    sheet.write(i, 9, line[9])
    sheet.write(i, 10, line[10])
    i = i + 1
 
file.save('北京数据.xls')