python读取json文件转成excel

wang_rx

　　import json
　　import xlwt
　　def readFromJson(file):
　　with open(file, 'r', encoding='utf8') as fr:
　　jsonData = json.load(fr)
　　return jsonData
　　def writeToExcel(file):
　　json = readFromJson(file)
　　excel = xlwt.Workbook()
　　sheet1 = excel.add_sheet('sheet1', cell_overwrite_ok=True)
　　sheet2 = excel.add_sheet('sheet2', cell_overwrite_ok=True)
　　length = len(json)
　　i = 0
　　while i < length:
　　eachLine = json
　　questions = eachLine['questions']
　　answer = eachLine['answer']
　　questionSize = len(questions)
　　if (questionSize > 256):
　　print(i + 1, questionSize)
　　j = 0
　　while j < questionSize:
　　ques = questions[j]
　　eachQues = ques['question']
　　if j < 256:
　　sheet1.write(i, j, eachQues)
　　if j == 0:
　　sheet2.write(i, 0, eachQues)
　　j = j + 1
　　sheet2.write(i, 1, answer)
　　i = i + 1
　　excel.save('doc/answer.xls')
　　if __name__ == '__main__':
　　writeToExcel('doc/kb.json')