python编程读取写入excel_Python读取txt内容写入xls格式excel中的方法

由于xlwt目前只支持xls格式，至于xlsx格式，后面会继续更新

import xlwt

import codecs

def Txt_to_Excel(inputTxt,sheetName,start_row,start_col,outputExcel):

fr = codecs.open(inputTxt,'r')

wb = xlwt.Workbook(encoding = 'utf-8')

ws = wb.add_sheet(sheetName)

line_number = 0#记录有多少行，相当于写入excel时的i，

row_excel = start_row

try:

for line in fr :

line_number +=1

row_excel +=1

line = line.strip()

line = line.split(' ')

len_line = len(line)#list中每一行有多少个数，相当于写入excel中的j

col_excel = start_col

for j in range(len_line):

print (line[j])

ws.write(row_excel,col_ex