|
我为什么要发这个贴?因为彩票比较热门,关注的人多,换句话就是应用性强。比如跟12306火车票搭点边就火。
在论坛中有些技术含量很高的帖子,但是没有被热门,就冷落在论坛某个角落里。
本帖无技术含量,不是用来学习的,只是急大家所需。
数据采集自重庆时时彩:http://data.shishicai.cn/cqssc/haoma/
网站升级后,有防盗链限制,而且必须要Cookie提交。原先的方法不能用,现帮大家更新。附件如下 (附件中有XMLHTTP和IE两种方法)
重庆时时彩自动更新号码.zip
(24.12 KB, 下载次数: 2227)
代码如下:
Sub Quick_refresh()
Dim cookies, arr As Variant, XML As Object
Set XML = CreateObject("WinHttp.WinHttpRequest.5.1") '("Msxml2.XMLHTTP.5.0")
With XML
'获取COOKIE - START
.Open "GET", "http://data.shishicai.cn/cqssc/haoma/", False
.Send
cookies = Split(.getallResponseHeaders(), "Set-Cookie: ")
For i = LBound(cookies) + 1 To UBound(cookies)
ckvalue = IIf(ckvalue = "", Split(cookies(i), ";")(0), ckvalue + "; " + Split(cookies(i), ";")(0))
Next
'获取COOKIE - END
.Open "POST", "http://data.shishicai.cn/handler/kuaikai/data.ashx", False
.setRequestHeader "Referer", "http://data.shishicai.cn/cqssc/haoma/"
.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
.setRequestHeader "Cookie", ckvalue
.Send "lottery=4&date=0001-01-01"
lotsdata = Replace(Split(Split(.responsetext, "[")(1), "]")(0), """", "")
arr = Split(lotsdata, ",")
Columns("A:C").ClearContents
Range(Cells(1, 1), Cells(1, 3)).Value = Array("期号", "开奖号码", "开奖时间")
For i = LBound(arr) To UBound(arr)
Range(Cells(i + 2, 1), Cells(i + 2, 3)).Value = Split(arr(i), ";")
Next
End With
Set XML = Nothing
MsgBox "OK"
End Sub
|
评分
-
3
查看全部评分
-
|