36、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=D937CD8CF62BD7C3BA472A603E4D0B43A8EA112D6B2F456E6AE94EBA2783A4F4EF69CB43118F67F368CE5800A9BC962B68BA37A26D3926C5746BC4D7E981CADE5819868EFE3DA3609DF01530F5CB21705702B0CBCC8724350E5CA6BA338C76DC3C13ACC6E3BF1E8B9D1FFAE767A3DFEE081D5CEF0A1E37CF6710517B3859ABAEA431E407C3B5AE59688B1AA694E1ADD0; 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-0801.xlsx') # print(r.text) </code></pre>