37、post_record

<pre><code> import requests import json p_url = 'http://123.57.22.247:19999/VehicleTestRecordNew.aspx' headers = { "Accept":"*/*", "Accept-Encoding":"gzip, deflate", "Accept-Language":"zh-CN,zh;q=0.8", "Content-Length":"1034", "Content-Type":"application/x-www-form-urlencoded; charset=UTF-8", "Cookie":".ASPXAUTH=CD513564EE366103D95330F28FB6CCC677CD5E42A366196B5B3EA700D62E5B27B78832C6E148F74C36068D4B94BC2CE144EF9A7D048A91D7F2D46325C35E35F5AAF9D37DFEC880798A8DE712BA93EDC4893620FBD03F51C5A3B59049F34667077A4A792F01DD5602635D372D0A73FF381C41CE8EB1CDC94D72ED5BF107B05537067AD7478E92D89B470F57737E8D45D1; xtooltech_infos=cultureInfo=zh-cn", "Host":"123.57.22.247:19999", "Origin":"http://123.57.22.247:19999", "Proxy-Connection":"keep-alive", "Referer":"http://123.57.22.247:19999/VehicleTestRecordNew.aspx", "User-Agent":"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36 SE 2.X MetaSr 1.0", "X-Requested-With":"XMLHttpRequest" } item_list = [] for i in range(10): a = {"sp_Recorder":"","sp_Recorder_cp":"","sp_RecTimeMin":"","sp_RecTime_cp":"","sp_DevType":"","sp_DevType_cp":"","sp_RecTimeMax":"","sp_VehSerial":"","sp_VehSerial_cp":"","sp_Due":"","sp_Due_cp":"","sp_VehType":"","sp_VehType_cp":"","sp_SolvedSoftVer":"","sp_SolvedSoftVer_cp":"","sp_VehYear":"","sp_VehYear_cp":"","sp_VehChassis":"","sp_VehChassis_cp":"","sp_VinCode":"","sp_VinCode_cp":"","sp_TestPath":"","sp_TestPath_cp":"","sp_IssueStatus":"","sp_IssueStatus_cp":"","sp_Principal":"","sp_Principal_cp":"","sp_RecordNO":"","sp_RecordNO_cp":"","sp_AuditStatus":"","sp_AuditStatus_cp":"","sp_PageIndex":i,"sp_PageSize":15} content={ 'act':'search', 'parameters': str(a) } r=requests.post(p_url,data=content,headers=headers) sample = json.loads(r.text) data_list = sample["Data"] for item in data_list: item["问题描述"] = item["VehSysInfos"][0]["IssueStatus"] item_list.append(item) # print(item["Id"]) print(sample["PageIndex"]) # item_list.append(r.text) # 转换成excel文件 from pandas.core.frame import DataFrame data = DataFrame(item_list) data.to_excel('./record-0723.xlsx') # print(r.text) </code></pre>