python 从txt写入xlsx

import xlwt
import os
import sys

def txt_xls(filename,xlsname):
	try:
		f = open(filename)
		xls = xlwt.Workbook()
		#生成excel的方法，声明excel
		#sheet = xls.add_sheet('11',cell_overwrite_ok=True)
		sheet = xls.add_sheet('11')
		#先写表头  0行 0列 
		sheet.write(0,0,"ip")
		sheet.write(0,1,"sernum")
		sheet.write(0,2,"katype")
		sheet.write(0,3,"time")
		sheet.write(0,4,"serverid")
		sheet.write(0,5,"UUID")
		sheet.write(0,6,"token")
		sheet.write(0,7,"guid")
		sheet.write(0,8,"uid")
		sheet.write(0,9,"channel")
		sheet.write(0,10,"platform")
		sheet.write(0,11,"logtype")
		sheet.write(0,12,"taskId")
		sheet.write(0,13,"point")
		sheet.write(0,14,"times")

		x = 1   #在excel开始写的位置（y）
		while True:     #循环读取文本里面的内容
			line = f.readline()     #一行一行的读
			if not line:    #如果没有内容，则退出循环
				break
			line = line.split('|')
			#print(line)
			length = len(line)
			for i in range(length):
				item = line[i]
				#item = np.float(item) # 为后面使用数据l进行计算，将其转换成数值型
				#x行，i列
				sheet.write(x,i,item)
			#for i in range(len(line.split('|'))):   #\t即tab健分隔
					#item = line.split('|')[i]
					#sheet.write(x,i,item)      #x单元格经度，i单元格纬度
			x += 1  #另起一行
		f.close()
		xls.save(xlsname)        #保存为xls文件
	except:
		raise


if __name__ == '__main__':
	filename = 'E:/BaiduNetdiskDownload/test.txt'
	xlsname = 'E:/BaiduNetdiskDownload/bella.xls'
	txt_xls(filename,xlsname)