37,720
社区成员
发帖
与我相关
我的任务
分享
# -*- coding: utf-8 -*-
"""
Created on Mon Feb 29 11:17:17 2016
@author: Administrator
"""
import xlwt
i = 0
file1 = open("002.txt","r")
file2 = open("out.txt","w")
while True:
line = file1.readline()
i += 1
if 55<=i and i<=66:
file2.write(line)
if i >66 :
break
if not line:
break
file1.close()
file2.close()
obj=open("out.txt","r")
all_txt=obj.read()
out_txt=eval(all_txt)
wb=xlwt.Workbook()
sheet=wb.add_sheet('shuju')
#
n=0
for k in obj.readlines():
dickkey = str(k)
sheet.write(n,0,dickkey)
m=1
print"标准内力信息===",dickkey
vals =out_txt.get(dickkey,None)
if vals is None:
vals=out_txt.get(k,None)
print "vals==========",vals
for item in vals :
import types
if type(item) is types.StringType :
item=item.strip().decode('gbk')
if type(item) is types.IntType:
continue
sheet.write(n,m ,item )
m=m+1
n=n+1
obj.close()
wb.save("out.xls")
for item in line.split("\t") :
有可能line不是用\t分割的, 所以item只有一个, 就是整个line. 用split()可以在任何空白处分割.# -*- coding: utf-8 -*-
"""
Created on Mon Feb 29 11:17:17 2016
@author: Administrator
"""
import xlwt
i = 0
file1 = open("002.txt","r")
file2 = open("out.txt","w")
while True:
line = file1.readline()
i += 1
if 51<=i and i<=66:
file2.write(line)
if i >66 :
break
if not line:
break
file1.close()
file2.close()
obj=open("out.txt","r")
wb=xlwt.Workbook()
sheet=wb.add_sheet('shuju')
#
n=0
for line in obj.readlines():
m=0
for item in line.split("\t") :
try:
item=item.strip().decode('gbk')
except UnicodeDecodeError:
print n,m,item
sheet.write(n,m,"NULL")
else:
sheet.write(n,m,item)
m=m+1
n=n+1
obj.close()
wb.save("out.xls")