|
- Sub getwebdata()
- '需要安装ACTIVERUBY ,下载地址 http://www.artonx.org/data/asr/Ruby-2.1.1.msi
- Dim url, y
- Set oJs = CreateObject("scriptcontrol"): oJs.Language = "rubyscript"
- For Each Cell In Selection
- url = Cell.Value
- y = oJs.eval("require 'open-uri';r=Regexp.new('decTxtAucPrice,StartPrice,EndTime,SellerID'.gsub(/,/,'|'));s=open(%Q(" & url & "),&:read).to_s.scan(/#{r}"">([\s\S]*?)</).flatten.insert(2,'').map{|x|x.encode('gbk').gsub(10.chr,'')}")
- y1 = oJs.eval("require 'open-uri';s=open(%Q(" & url & "),&:read).to_s.scan(/title>(.+?)(?=\-)/)[0][0].encode('gbk')")
- Cell(1, 2).Resize(1, 5) = y
- Cell(1, -1) = y1
- Next
- Set oJs = Nothing
- Columns("a:h").AutoFit
- 'Stop
- End Sub
复制代码 |
|