python获取txt多行文本中的数据,存入到excel
上一篇 /
下一篇 2018-05-24 16:48:41
/ 个人分类:Selenium
import os
import xlwt
import re
knowledge = []
def write_excel(knowledge):
# 创建xls工作薄
workbook = xlwt.Workbook(encoding='utf-8')
# 创建sheet
data_sheet = workbook.add_sheet('first')
for i in range(len(knowledge)):
data_sheet.write(i, 0, knowledge[i][0])
data_sheet.write(i, 1, knowledge[i][1])
data_sheet.write(i, 2, knowledge[i][2])
# 保存文件
workbook.save('Report.xls')
x = xlwt.Workbook()
s1 = x.add_sheet('sheet1')
if __name__ == '__main__':
myfile = open('Message.txt', 'r')
line = myfile.readline()
while line:
#获取行中的数据值
list=re.findall(r"\d+\.?\d*", line)
#print (list)
knowledge.append(list)
write_excel(knowledge)
line = myfile.readline()
myfile.close()
收藏
举报
TAG: