title: import excel column in python list
body: <p>Hi I have an excel sheet with only 1 column and i want to import that column into a list in python.
  It has 5 elements in that column, all containing a url like "<a href="http://dl.dropboxusercontent.com/sh/hk7l7t1ead5bd7d/AAACc6yA_4MhwbaxX_dizyg3a/NT51-177/DPS_0321.jpg?dl=0" rel="nofollow">http://dl.dropboxusercontent.com/sh/hk7l7t1ead5bd7d/AAACc6yA_4MhwbaxX_dizyg3a/NT51-177/DPS_0321.jpg?dl=0</a>".</p>
  
  <p>My code</p>
  
  <pre><code>import requests
  import csv
  import xlrd
  
  ls = []
  ls1 = ['01.jpg','02.jpg','03.jpg','04.jpg','05.jpg','06.jpg']
  wb = xlrd.open_workbook('Book1.xls')
  ws = wb.sheet_by_name('Book1')
  num_rows = ws.nrows - 1
  curr_row = -1
  while (curr_row &lt; num_rows):
      curr_row += 1
      row = ws.row(curr_row)
      ls.append(row)
  
  for each in ls:
      urlFetch = requests.get(each)
      img = urlFetch.content
      for x in ls1:
          file = open(x,'wb') 
          file.write(img)
          file.close()
  </code></pre>
  
  <p>Now it is giving me error:</p>
  
  <pre><code>Traceback (most recent call last):
    File     "C:\Users\Prime\Documents\NetBeansProjects\Python_File_Retrieve\src\python_file_retrieve.py", line   18, in &lt;module&gt;
  urlFetch = requests.get(each)
    File "c:\Python34\lib\site-packages\requests-2.5.0-py3.4.egg\requests\api.py", line 65, in get
  return request('get', url, **kwargs)
    File "c:\Python34\lib\site-packages\requests-2.5.0-py3.4.egg\requests\api.py", line 49, in request
  response = session.request(method=method, url=url, **kwargs)
    File "c:\Python34\lib\site-packages\requests-2.5.0-py3.4.egg\requests\sessions.py", line 461, in request
      resp = self.send(prep, **send_kwargs)
    File "c:\Python34\lib\site-packages\requests-2.5.0-py3.4.egg\requests\sessions.py", line 567, in send
      adapter = self.get_adapter(url=request.url)
    File "c:\Python34\lib\site-packages\requests-2.5.0-py3.4.egg\requests\sessions.py", line 646, in get_adapter
      raise InvalidSchema("No connection adapters were found for '%s'" % url)
  requests.exceptions.InvalidSchema: No connection adapters were found for '[text:'https://dl.dropboxusercontent.com/sh/hk7l7t1ead5bd7d/AAACc6yA_4MhwbaxX_dizyg3a/NT51-177/DPS_0321.jpg?dl=0']'
  </code></pre>
  
  <p>Please Help</p>