非同期のデータを取り込む

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)