json転送excelドキュメント

json展示

{"pinpai": "  ,  ", "daihao": "LJ9LFJ", "name": "             ", "address": "           5 ", "leixing": "10   10,10  10,10  "}
{"pinpai": "   ", "daihao": "LA9XHD", "name": "                ", "address": "                      ", "leixing": "10  10,10  "}

上は私のjsonフォーマットです
コードディスプレイ

# -*- coding: utf-8 -*
import json,xlwt,os

def readjson():
    file_object1 = open('mcdatadata.json','r')  #    
    try:
        while True:
            line = file_object1.readline()
            print line
            data = json.loads(line) #  json  load  ， json      
            s.append(data)#          
    finally:
        return s


def writeM():
    datas = readjson()
    title = ['pinpai','daihao','name','address','leixing']
    book = xlwt.Workbook() #     excel  
    sheet = book.add_sheet('Sheet1',cell_overwrite_ok=True) #     sheet 
    for i in range(len(title)): #    
        sheet.write(0,i,title[i]) #  title         0 i  
    for i in range(len(datas)):#    ，         
        b = datas[i]# i     
        massage = b#        
        l = [massage[k] for k in title]#      title         
        for k1 in range(len(l)): #　    
            sheet.write(1+i,k1,l[k1]) #　      i+1  k1  
    book.save('mc123123.xls')#  excel

if __name__ == '__main__':
    writeM()
    # readjson()