非同期のデータを取り込む
1441 ワード
もっと読む
def asta_data
resp = HTTParty.post("http://si.12333.gov.cn/118733/RemoteQuery003.jspx")
result = resp.parsed_response
book = Spreadsheet::Workbook.new
sheet = book.create_worksheet
row = sheet.row 0
row.concat %w( )
index = 1
result["lists"]["resultset"]["list"].each do |detail|
row = sheet.row(index)
detail_aka101 = detail["aka101"]
#(case detail["aka101"] when '01' then ' ' when '02' then ' ' end )
detail_akb023 = detail["akb023"]
#(case detail["akb023"] when '15' then ' ' end )
row.concat [index,detail["aab299"],detail["akb021"],detail["akb020"],detail_aka101,detail_akb023,detail["aae006"],detail["aae005"]]
index += 1
end
string_io = StringIO.new
book.write string_io
send_data string_io.string, filename: "yiyuan_list.xls"
end
resources = HTTParty.get(image_path)
file = File.new("/Users/zy/Desktop/ /#{file_name}", 'w+')
file.syswrite(resources)