今天打開github，發(fā)現(xiàn)Ruby的spreadsheet包竟然年久失修螃壤，不支持xlsx格式。
綜合比較了下混卵，發(fā)現(xiàn)fast_excel包比creek包還是好用映穗。
滬深A股數(shù)據(jù)依然源自東方財富網(wǎng)窖张。
fast_excel包比原生的win32ole包速度快了幾倍幕随。
代碼如下所示：
# -*- coding: UTF-8 -*-
require "url"
require "json"
require "fast_excel"
begin
abc = URL.new("http://73.push2.eastmoney.com/api/qt/clist/get?pn=1&pz=20&po=1&np=1&ut=bd1d9ddb04089700cf9c27f6f7426281&fltt=2&invt=2&fid=f3&fs=m:0+t:6,m:0+t:80,m:1+t:2,m:1+t:23&fields=f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f12,f13,f14,f15,f16,f17,f18,f20,f21,f23,f24,f25,f22,f11,f62,f128,f136,f115,f152")
sum = abc.get.json["data"]["total"].to_s
url = URL.new("http://73.push2.eastmoney.com/api/qt/clist/get?pn=1&pz=#{sum}&po=1&np=1&ut=bd1d9ddb04089700cf9c27f6f7426281&fltt=2&invt=2&fid=f3&fs=m:0+t:6,m:0+t:80,m:1+t:2,m:1+t:23&fields=f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f12,f13,f14,f15,f16,f17,f18,f20,f21,f23,f24,f25,f22,f11,f62,f128,f136,f115,f152")
filename = "hushenAstock" + Time.now.strftime("%Y%m%d%H%M%S") + ".xlsx"
data = url.get.json["data"]["diff"]
workbook = FastExcel.open("#{filename}", constant_memory: true)
worksheet = workbook.add_worksheet("滬深A股")
worksheet.append_row(["股票名稱", "股票代碼", "最新價", "跌漲幅", "跌漲額", "成交量", "成交額", "振幅", "換手率", "市盈率", "量比", "最高", "最低", "今開", "昨收", "市凈率"])
for i in 2..data.length+1
worksheet.append_row([data[i-2]["f14"], "=TEXT(#{data[i-2]["f12"]},\"000000\")", data[i-2]["f2"], data[i-2]["f3"] == "-" ? data[i-2]["f3"] : data[i-2]["f3"].to_s + "%", data[i-2]["f4"], data[i-2]["f5"], data[i-2]["f6"], data[i-2]["f7"] == "-" ? data[i-2]["f7"] : data[i-2]["f7"].to_s + "%", data[i-2]["f8"] == "-" ? data[i-2]["f8"] : data[i-2]["f8"].to_s + "%", data[i-2]["f9"], data[i-2]["f10"], data[i-2]["f15"], data[i-2]["f16"], data[i-2]["f17"], data[i-2]["f18"], data[i-2]["f23"]])
end
workbook.close
rescue Exception => e
puts e.message
puts e.backtrace.inspect
ensure
puts "Program end!"
end
結果如下鏈接文章所示：
Ruby抓取滬深A股數(shù)據(jù)
