Python一个http请求解析JSON生成xls的例子

#!/usr/bin/python
#coding=utf-8

import urllib
import urllib2
import json
import time
import random
import xlwt
print "开始更新题库~"
workbook = xlwt.Workbook(encoding = 'utf-8')
worksheet = workbook.add_sheet('My Worksheet')

header_data = {"User-Agent" : "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0;","accept":"application/json"} 
roundRequrl="https://qy.51vj.cn/examination/external/person/results/94268?corpid=wx68d419f193513aed&appid=52&_=1587739065112&token=Lp7FvfbO0T2YxbwSMZ4mVA%3D%3D"

req = urllib2.Request(url = roundRequrl,headers=header_data)
resp = urllib2.urlopen(req)    
page_data = resp.read()
text = json.loads(page_data)
listq=text["exam_results"]
for i in range(len(listq)):
    requrl = "https://qy.51vj.cn/examination/external/questions/person/94268?corpid=wx68d419f193513aed&appid=52&_=1587718041400&id=94268&round="+str(listq[i]["round"])+"&need_answer=true&token=Lp7FvfbO0T2YxbwSMZ4mVA%3D%3D"
    req = urllib2.Request(url = requrl,headers=header_data)
    resp = urllib2.urlopen(req)    
    page_data = resp.read()
    #print page_data 
    text = json.loads(page_data)
    
    lista=text["exam_questions"]
    cnt = i * 50
    for j in range(len(lista)):
        worksheet.write(cnt+j, 0, lista[j]["id"]) 
        worksheet.write(cnt+j, 1, lista[j]["title"])
        worksheet.write(cnt+j, 2, lista[j]["right_answer"])    
workbook.save('formatting.xls') # 保存文件
print "题库更新完成！"