|
Sub test()
Dim winhttp As Object
Dim json As Object
Dim rows, id, element, price, i As Byte
Dim arr(1 To 250, 1 To 10)
Set winhttp = CreateObject("winhttp.winhttprequest.5.1")
Set json = CreateObject("msscriptcontrol.scriptcontrol")
With winhttp
.Open "POST", "https://www.jisilu.cn/data/cbnew/cb_list/?___jsl=LST___t=1580436871866", False
.setrequestheader "referer", "https://www.jisilu.cn/data/cbnew/"
.SEND "fprice=&tprice=&volume=&svolume=&premium_rt=&ytm_rt=&rating_cd=&is_search=N&btype=&listed=Y&sw_cd=&bond_ids=&rp=50&page=1"
With json
.Language = "jscript"
.addcode "var d=" & winhttp.responsetext
Set json = json.codeobject.d.rows
For Each element In json
i = i + 1
arr(i, 1) = element.id
arr(i, 2) = element.cell.bond_nm
arr(i, 3) = element.cell.price
Next
End With
End With
[a1].Resize(250, 10) = arr
End Sub
|
|