用 Python 10 分钟导出网站题库(自动抓取 + 生成 Excel)

{"success":true,"msg":"操作成功","obj":[168,169,170,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,203,204,205,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,256,257,259,260,261,263,264,265,266,268,270,271,272,273,274,275,276,277,278,279,281,283,284,285,286,288,289,290,292,293,294,295,298,299,300,301,302,303,304,305,306,307,308,310,312,313,314,315,316,317,318,319,320,323,324,325,326,327,328,329,331,333,334,335,336,338,339,340,341,342,344,346,347,348,350,351,352,353,356,359,360,361,362,363,365,366,367,368,369,371,374,376,377,378,379,380,381,382,383,384,385,387,388,389,390,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,411,412,413,414,416,417,418,419,421,422,423,424,425,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,450,451,452,453,454,455,456,457,458,459,460,461,462,464,465,466,467,468,469,470,471,472,473,474,476,477,478,479,480,481,482,484,485,486,487,488,489,490,491,494,495,496,497,498,499,500,501,502,503,504,505,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,586,587,589,590,591,592,593,594,596,598,599,600,601,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,622,623,624,625,627,629,631,632,633,634,635,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,665,666,667,669,670,672,674,676,677,679,680,681,682,683,684,685,932,933,934,935,936,937,938,939,940,942,944,947,948,949,950,951,952,954,955,956,957,958,959,960,963,966,967,968,970,971,973,975,977,979,981,982,983,984,986,987,990,991,994,995,996,997,998,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1017,1025,1026,1027,1028,1029,1030,1031,1033,1034,1035,1037,1038,1039,1040,1041,1042,1043,1047,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1062,1063,1064,1065,1066,1067,1068,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1093,1094,1095,1096,1098,1099,1102,1103,1105,1106,1107,1108,1109,1111,1112,1113,1114,1115],"attributes":null}

{"success":true,"msg":"操作成功","obj":{"gmtCreate":null,"gmtModified":null,"deleted":false,"id":168,"classifyId":3,"shortTitle":"国家秘密的密级分为","title":"<p>国家秘密的密级分为</p>","type":1,"difficultyLevel":0.7,"demand":"","status":0,"auditStatus":1,"auditRemark":"","createUser":1035,"difficultyLevelStr":null,"optionList":[{"gmtCreate":null,"gmtModified":null,"deleted":false,"id":804,"questionId":168,"content":"绝密、机密、秘密三级","sort":2,"isRight":1,"tag":""},{"gmtCreate":null,"gmtModified":null,"deleted":false,"id":805,"questionId":168,"content":"绝密、秘密、工作秘密三级","sort":3,"isRight":0,"tag":""},{"gmtCreate":null,"gmtModified":null,"deleted":false,"id":806,"questionId":168,"content":"机密、秘密、工作秘密三级","sort":4,"isRight":0,"tag":""},{"gmtCreate":null,"gmtModified":null,"deleted":false,"id":807,"questionId":168,"content":"全都错误","sort":5,"isRight":0,"tag":""}],"auditRecordList":null,"classifyCode":null,"classifyName":null,"createUserName":"中心管理员","sort":null},"attributes":null}

import requestsimport urllib3import timefrom openpyxl import Workbookurllib3.disable_warnings()BASE_URL = "http://wjwtrain.bcvet.com.cn"headers = {    "Accept": "*/*",    "Accept-Language": "zh-CN,zh;q=0.9,en;q=0.8",    "Connection": "keep-alive",    "Referer": "http://wjwtrain.bcvet.com.cn/",    "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36",    "X-Requested-With": "XMLHttpRequest"}cookies = {    "JSESSIONID": "",    "wjwTrain-server": "",    "userId": "",    "username": "",    "SERVERID": ""}session = requests.Session()session.headers.update(headers)session.cookies.update(cookies)# 获取题目IDdef get_question_ids():    url = f"{BASE_URL}/api/api/practice/77/questionIdList"    params = {"sourceType": "project"}    r = session.get(url, params=params, verify=False)    data = r.json()    return data["obj"]# 获取题目def get_question(qid):    url = f"{BASE_URL}/api/api/practice/{qid}/questionInfo"    r = session.get(url, verify=False)    data = r.json()    obj = data["obj"]    title = obj["shortTitle"]    answer = ""    for option in obj["optionList"]:        if option["isRight"] == 1:            answer = option["content"]            break    return title, answerdef main():    ids = get_question_ids()    print("题目数量:", len(ids))    results = []    for qid in ids:        try:            title, answer = get_question(qid)            print(f"{qid}{title} -> {answer}")            results.append((title, answer))            time.sleep(0.05)        except Exception as e:            print("error:", qid, e)    # ===== 导出Excel =====    wb = Workbook()    ws = wb.active    ws.title = "题库"    ws.append(["题目", "答案"])    for title, answer in results:        ws.append([title, answer])    wb.save("questions.xlsx")    print("完成，已导出 questions.xlsx")if __name__ == "__main__":    main()