怎样把txt导入python_python 将txt导入excel

贴一段代码给你参考参考吧：

import xlwt

def set_style(name,height,bold=False):

style = xlwt.XFStyle()

font = xlwt.Font()

font.name = name

font.bold = bold

font.color_index = 4

font.height = height

style.font = font

return style

def write_excel():

f = xlwt.Workbook()

sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True)

row0 = ['1','2','3','4','5','6','7','8']

column0 = ['a','b','c','d','e']

status = ['q1','q2','q3','q4']

for i in range(0,len(row0)):

sheet1.write(0,i,row0[i],set_style('Times New Roman',220,True))

i, j = 1, 0

while i < 4*len(column0) and j < len(column0):

sheet1.write_merge(i,i+3,0,0,column0[j],set_style('Arial',220,True))

sheet1.write_merge(i,i+3,7,7)

i += 4

j += 1

sheet1.write_merge(21,21,0,1,'total',set_style('Times New Roman',220,True))

i = 0

while i < 4*len(column0):

for j in range(0,len(status)):

sheet1.write(j+i+1,1,status[j])

i += 4

f.save('demo1.xls')

if __name__ == '__main__':

write_excel()