title: Python: How to handle excel data from web without saving file
body: <p>I'm new to python and having trouble dealing with excel manpulation in python. </p>
  
  <p>So here's my situation: I'm using requests to get a .xls file from a web server. After that I'm using xlrd to save the content in excel file. I'm only interested in one value of that file, and there are thousands of files im retrieving from different url addresses. </p>
  
  <p>I want to know how could i handle the contents i get from request in some other way rather than creating a new file.</p>
  
  <p>Besides, i've included my code my comments on how could I improve it. Besides, it doesn't work, since i'm trying to save new content in an already created excel file (but i couldnt figure out how to delete the contents of that file for my code to work (even if its not efficient)).</p>
  
  <pre><code>import requests
  import xlrd
  d={}
  for year in string_of_years:
      for month in string_of_months:  
          dls=" http://.../name_year_month.xls"
          resp = requests.get(dls)
          output = open('temp.xls', 'wb')
          output.write(resp.content)
          output.close()
          workbook = xlrd.open_workbook('temp.xls')
          worksheet = workbook.sheet_by_name(mysheet_name)
          num_rows = worksheet.nrows
          for k in range(num_rows):
              if condition I'm looking for:
                  w={key_year_month:worksheet.cell_value(k,0)}
                  dic.update(w)
                  break
  </code></pre>