|
也来凑个热闹- Sub Test20150301()
- Dim Url As String, St As String
- Dim js As Object
- Dim arrdata(1 To 100000, 1 To 11), ar
- Url = "http://183.136.160.18/EM_DataCenter/js.aspx?type=SR&sty=HYSR&mkt=0&stat=0&cmd=2&code=&sc=&ps=1&js=(pc),(x)&p=1&rt=" & Rnd
- Set js = CreateObject("MSScriptControl.ScriptControl")
- js.Language = "javascript"
- With CreateObject("MSXML2.XMLHTTP")
- .Open "GET", Url, False
- .send
- '获取总记录数
- St = .responsetext: St = Split(St, ",")(0)
- '改变参数,一次性读取
- Url = "http://183.136.160.18/EM_DataCenter/js.aspx?type=SR&sty=HYSR&mkt=0&stat=0&cmd=2&code=&sc=&ps=" & St & "&p=1&js=var%20dy={%22data%22:[(x)],%22pages%22:%22(pc)%22,%22update%22:%22(ud)%22,%22count%22:%22(count)%22}&rt=" & Rnd
- .Open "GET", Url, False
- .send
- js.addcode (.responsetext)
- End With
- '双数组操作,未测试读写速度
- For i = 0 To js.eval("dy.data.length") - 1
- ar = Split(js.eval("dy.data[" & i & "]"), ",")
- For j = 0 To 10
- arrdata(i + 1, j + 1) = ar(j)
- Next j
- Next
- Cells.Clear: Cells(2, 1).Resize(i, j + 1) = arrdata
- End Sub
复制代码 |
|