我试图用python打开一个excel.xlsx文件,但是找不到方法,我试过使用pandas,但是它想使用一个名为NumPy的库,我试过安装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