|
- Sub getwebdata()
- Dim url$, html As Object, xmlhttp As Object, p&, n&, i%, j%
- Set html = CreateObject("htmlfile")
- Set xmlhttp = CreateObject("msxml2.xmlhttp")
- For p = 0 To 1371
- url = "http://210.75.206.60/tjsqba/applyInfo.do?method=getallApplyList&serialNumber=&name=&pdeptid=&updeptid=&page_flag=true&pagesize_key=default&page_order=&goto_page=next¤t_page=" & p & "&total_count=13715&to_page="
- With xmlhttp
- .Open "get", url, False
- .send
- html.body.innerhtml = .responseText
- End With
- Set tb = html.body.getelementsbytagname("tr")
- For i = IIf(p > 0, 8, 7) To tb.Length - 5
- n = n + 1
- For j = 0 To tb(i).childnodes.Length - 1
- Sheet1.Cells(n, j + 1) = tb(i).childnodes(j).innertext
- Next
- Next
- Next
- Set html = Nothing
- Set xmlhttp = Nothing
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|