先上代码:
#coding:utf-8
import xlwt
import sys
reload(sys)
sys.setdefaultencoding('utf-8')
style = xlwt.XFStyle()
font = xlwt.Font()
font.name = 'SimSun' # 指定“宋体”
style.font = font
wb = xlwt.Workbook(encoding='utf-8') #指定文件编码
ws = wb.add_sheet("sheet1")
f=open("SH600030.txt") #读取文件
for row,line in enumerate(f):
lienArr = line.split("\t") #行截取
for col,cell in enumerate(lienArr):
ws.write(row,col,cell,style)
wb.save('sh.xls')