title: Opening and reading an excel .xlsx file in python
body: <p>I'm trying to open an excel .xlsx file with python but am unable to find a way to do it, I've tried using pandas but it's wanting to use a library called NumPy I've tried to install numpy but it still can't find numpy.</p>
  
  <p>I've also tried using the xlrd library but I get the following traceback:</p>
  
  <pre><code>Traceback (most recent call last):
    File "C:\test.py", line 3, in &lt;module&gt;
      book = open_workbook('test.xlsx')
    File "C:\Python27\lib\site-packages\xlrd\__init__.py", line 370, in open_workbook
      biff_version = bk.getbof(XL_WORKBOOK_GLOBALS)
    File "C:\Python27\lib\site-packages\xlrd\__init__.py", line 1323, in getbof
      raise XLRDError('Expected BOF record; found 0x%04x' % opcode)
  XLRDError: Expected BOF record; found 0x4b50
  </code></pre>
  
  <p>Which I assume is because XLRD can't read .xlsx files?</p>
  
  <p>Anyone got any ideas?</p>
  
  <p>EDIT: </p>
  
  <pre><code>import csv
  with open('test.csv', 'rb') as csvfile:
      data = csv.reader(csvfile, delimiter=',')
      for row in data:
          print "------------------"
          print row
          print "------------------"
          for cell in row:
              print cell
  </code></pre>