|
本帖最后由 duquancai 于 2019-1-24 23:01 编辑
这是ExcelVBA代码》》》》》》》》》》》》》》》》》》》》》》》》- Sub main()
- my_name$ = "username=pnrsandy" '用户名
- my_pwd$ = "&password=PNR123456" '密码
- post_data$ = "pageNo=1&pageSize=20&cityCode=119900&productSortName=%E7%82%89%E6%96%99"
- Call login_get_json(my_name, my_pwd, post_data)
- MsgBox "ok!"
- End Sub
- Sub login_get_json(ByVal my_name$, ByVal my_pwd$, ByVal post_data$)
- Dim xmlhttp As Object
- Set xmlhttp = CreateObject("msxml2.xmlhttp")
- xmlhttp.Open "POST", "https://vip.ccmn.cn/a/login", False
- xmlhttp.send my_name & my_pwd
- xmlhttp.Open "POST", "https://www.ccmn.cn/historyprice/getCorpQuotationsList", False
- xmlhttp.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
- xmlhttp.send post_data
- Call parse_json(xmlhttp.responseText)
- End Sub
- Sub parse_json(ByVal json_sr$)
- Dim js As Object, j As String
- Sheets(1).Select: Cells.Clear
- Set js = CreateObject("MSScriptControl.ScriptControl")
- js.Language = "JavaScript": js.AddObject "g", Range("a1")
- j = "k=0;a=" & json_sr & "['body']['marketPriceList'];"
- j = j & "for(i=0;i<a.length;i++,k++){if(k==0){r=0;for(o in a[i]){++r;g(1,r)=o;g(2,r)=a[i][o]}"
- j = j & "}else{r=0;for(o in a[i]){++r;g(i+2,r)=a[i][o]}}};": js.eval (j)
- End Sub
复制代码 |
评分
-
3
查看全部评分
-
|