为了计算准确率,今天用python写了一个读取json字符串写入Excel的小脚本,哈哈,真不错。想想之前我处理一个一个的复制粘贴,这真是快多了。这是有史以来我写的最多行数的代码,囧啊!!
下面show一下我的代码,很搓,各种变量名乱窜,但也很不错了啊!^_^

#!/usr/bin/python
#coding:utf-8
import json
from compiler.ast import flatten
import copy
import xlrd
import xlwt

test_27result = json.load(open('/home/yangzhiwei/desktop/156.json', 'r'))
test_resulttemp = json.dumps(test_27result)
test_resultlist = json.loads(test_resulttemp)

online_3result = json.load(open('/home/yangzhiwei/desktop/345.json', 'r'))
onlinetemp = json.dumps(online_3result)
online_resultlist = json.loads(onlinetemp)

#print test_resultlist
#print online_resultlist

for itest in test_resultlist:
    testlist = test_resultlist[itest]
    #print test_resultlist[itest]

for ionline in online_resultlist:
    onlinelist = online_resultlist[ionline]

#print onlinelist

#print testlist[3][0] 
#print  "......................"

newtestlist = []
newtestlist = flatten(testlist)
len_newtestlist = len(newtestlist)

newonlinelist = []
newonlinelist = flatten(onlinelist)
#print newonlinelist
len_newonlinelist = len(newonlinelist)

data = xlrd.open_workbook('/home/yangzhiwei/desktop/demo.xls')
file = xlwt.Workbook()
sheet = file.add_sheet('sheet1',cell_overwrite_ok=True)
sheet2 = file.add_sheet('sheet2',cell_overwrite_ok=True)
print "Below is online data!!"

#sheet.write(0,0,"timea")
#file.save('demo.xls')

atime =[]
for i in range(0,len_newonlinelist,3):
    time = newonlinelist[i]
    #print time
    atime.append(time)
#print atime

for ii in range(0,len(atime)):
sheet.write(ii,1,atime[ii])
sheet2.write(ii,1,atime[ii])
file.save('demo.xls')

print "onlinetime write to sheet1 2 colnum and sheet2 2 colnum\n"
oleft = []
for j in range(1,len_newonlinelist,3):
    left = newonlinelist[j]
    oleft.append(left)
    #print left

for jj in range(0,len(oleft)):
sheet2.write(jj,2,oleft[jj])
file.save('demo.xls')

print "onlineleft write to sheet2 the 3 colnum \n" 

oright = []
for k in range(2,len_newonlinelist,3):
    right = newonlinelist[k]
    oright.append(right)

for kk in range(0,len(oright)):
sheet.write(kk,2,oright[kk])
file.save('demo.xls')

print "onlineright write to the sheet1 the 3 colnum\n"

print "Below is test data!"

t_time = []
for l in range(0,len_newtestlist,3):
    testtime = newtestlist[l]
    t_time.append(testtime)
   # print testtime

for ll in range(0,len(t_time)):
sheet.write(ll,3,t_time[ll])
sheet2.write(ll,3,t_time[ll])
file.save('demo.xls')

print "testtime write to the sheet1 the 4 colnum\n"
print "testtime write to the sheet2 the 4 colnum\n"

t_left = [] 
for m in range(1,len_newtestlist,3):
    testleft = newtestlist[m]
    t_left.append(testleft)
   # print testleft

for mm in range(0,len(t_left)):
sheet2.write(mm,4,t_left[mm])
file.save('demo.xls')

print "testleft write to the sheet2 the 5 colnum \n"

t_right = []
for n in range(2,len_newtestlist,3):
    testright = newtestlist[n]
    t_right.append(testright)
   # print testright

for nn in range(0,len(t_right)):
sheet.write(nn,4,t_right[nn])
file.save('demo.xls')

print "testright write to the sheet1 the 5 colnum\n" 
print "This is the end"