将txt数据从某一行开始写入excel文件中(例子为从Appthroughput写至excel_result1.xlsx中)
import sys
import random
import time
import xlwt
import codecs
def Txt_to_Excel(wb,inputTxt,start_row,start_col):
fr = codecs.open(inputTxt,'r')
line_number = 0
row_excel = start_row
for line in fr:
line =line.split()
col_excel =start_col;
wb.write(row_excel,col_excel,line)
line_number +=1
row_excel +=1
if __name__ == '__main__':
wb = xlwt.Workbook(encoding = 'utf-8')
ws1 = wb.add_sheet("AppThroughput")
startrow =0
dir1 = './Indicator/AppThroughput/AppThroughput-ECMP-X1--0.4-50.0ms.txt'
startcol1 =0
Txt_to_Excel(ws1,dir1,startrow,startcol1)
wb.save('excel_result1.xlsx')
参考链接:
python 数据处理3----读取txt 一列数据写入excel 文件
如何用python提取txt文件中的特定信息并写入Excel