python txt转Excel

import openpyxl
f=open("your.txt","r",encoding="utf8")
con=f.readlines()
w_path="your.xlsx"
wb=openpyxl.Workbook()
ws = wb.worksheets[0]//第一个工作表
flag=0
for data in con:
    flag+=1
    print(flag)
    datas=data.split("\t")
    ws.append(datas)//逐行写入
wb.save(w_path)
print("okk")