title: extract information from excel into python 2d array
body: <p>I have an excel sheet with dates, time, and temp that look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/RioSe.png" alt="enter image description here"></p>
  
  <p>using python, I want to extract this info into python arrays.</p>
  
  <p>The array would get the date in position 0, and then store the temps in the following positions and look like this:</p>
  
  <pre><code>temparray[0] = [20130102,34.75,34.66,34.6,34.6,....,34.86]
  temparray[1] = [20130103,34.65,34.65,34.73,34.81,....,34.64]
  </code></pre>
  
  <p>here is my attempt, but it sucks:</p>
  
  <pre><code>from xlrd import * 
  
  print open_workbook('temp.xlsx')
  
  wb = open_workbook('temp.xlsx')
  
  for s in wb.sheets():
      for row in range(s.nrows):
          values = []
          for col in range(s.ncols):
              values.append(s.cell(row,col).value)
          print(values[0])
          print("%.2f" % values[1])
          print'''
  </code></pre>
  
  <p>i used xlrd, but I am open to using anything. Thank you for your help.</p>