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)
python 从txt写入xlsx
最新推荐文章于 2023-02-22 08:30:27 发布