上干货，txt 文本的数据转 excel，给你带上注释

def txt_xls2(filename, xlsname):
try:
f = open(filename, ‘r’, encoding=‘GBK’)
xls = xlwt.Workbook()
sheet = xls.add_sheet(‘sheet1’, cell_overwrite_ok=True)
x = 0
while True:
# 按行循环，读取文本文件
line = f.readline()
if not line:
break
for i in range(len(line.split(‘\t’))):
print(line)
line2=‘,’.join(filter(lambda x: x, line.split(’ ‘)))
item = line2.split(’,’)
print(item)
print(‘line2:====’+line2)
for m in range(len(item)):
sheet.write(x, m, item[m])
x += 1
f.close()
xls.save(xlsname) # 保存 xls 文件
except:
raise