python读取xlsx文件找不到_在python中打开并读取excel .xlsx文件

我正在尝试使用python打开一个excel .xlsx文件,但我无法找到办法,我尝试使用pandas但是它想要使用一个名为NumPy的库我试图安装numpy但它仍然可以找不到.

我也尝试过使用xlrd库,但是我得到了以下回溯：

Traceback (most recent call last):

File "C:\test.py", line 3, in

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

我假设是因为XLRD无法读取.xlsx文件？

有人有任何想法吗？

编辑：

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