|
楼主 |
发表于 2018-7-7 09:27
|
显示全部楼层
记录一下:
Sub kao_js()
Application.ScreenUpdating = False
Dim html As Object, js As Object
Dim strText$, I%
Set html = CreateObject("msxml2.xmlhttp")
Range("a1").Resize(1, 10) = Split("法院 法庭 开庭日期 排期日期 案号 案由 承办部门 审判长/主审人 公诉人/原告/上诉人/申请人 被告/被告人/被上诉人/被申请人")
For I = 1 To InputBox("数据大约有12k条,下载较慢,页数范围在1-23", "获得查询的页数", 10)
html.Open "POST", "http://www.zjsfgkw.cn/Notice/NoticeKTSearch", False
html.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
html.send ("pageno=" & I & "&pagesize=500&cbfy=%E5%85%A8%E9%83%A8&")
Application.Wait Now() + VBA.TimeValue("00:00:02")
strText = html.responseText
If InStr(strText, "list") = False Then GoTo ghb
Set js = CreateObject("ScriptControl")
js.Language = "JavaScript": js.AddObject "g", Range("A1").Offset((I - 1) * 500)
js.eval "o=" & strText & ";l=['FY','FT','KTRQ','PQRQ','AH','AY','CBBM','SPZ','YG','BG'];a=o.list;for(i=0;i<a.length;i++){for(k=0;k<l.length;k++){g(i+2,k+1)=a[i][l[k]];}};"
Application.StatusBar = I * 500 & " 条数据ok!......"
Next
Application.ScreenUpdating = True
ghb:
Application.StatusBar = "ok!"
Application.Wait Now() + VBA.TimeValue("00:00:03")
Application.StatusBar = False
End Sub |
|