python将txt文件批量导入excel

txtname = 'G:/202008.txt'#txt路径
excelname = 'C:/Users/123/Desktop/202008.xls'#要保存的excel路径
 
fopen = open(txtname, 'r')
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.strip('\n')
    line = line.split(',')#txt列与列通过','分隔
    s = line[0]#有几列就建立几个line
    a = line[1]
    b = line[2]
    c = line[3]
    d = line[4]
    e = line[5]
    f = line[6]
    g = line[7]
    h = line[8]
    j = line[9]
    k = line[10]
    l = line[11]
    m = line[12]
    n = line[13]
    o = line[14]
    p = line[15]
    # print(company_num)
    # print(date)
    # print(baifenbi)
    # print(type(company_num))
 
 
    sheet.write(i, 0,s)
    sheet.write(i, 1, a)
    sheet.write(i, 2, b)
    sheet.write(i, 3,c)
    sheet.write(i, 4, d)
    sheet.write(i, 5, e)
    sheet.write(i, 6,f)
    sheet.write(i, 7, g)
    sheet.write(i, 8, h)
    sheet.write(i, 9,j)
    sheet.write(i, 10, k)
    sheet.write(i, 11,l)
    sheet.write(i, 12,m)
    sheet.write(i, 13, n)
    sheet.write(i, 14, o)
    sheet.write(i, 15,p)
    i = i + 1
 
file.save(excelname)#保存文件