代码：

from xlrd import open_workbook

input_file = 'e:\python\trade.xls'

# open_workbook(input_file) 打开一个工作簿

workbook = open_workbook(input_file)

# 输出此工作簿中有多少个表 workbook.nsheets

print('Number of worksheets: ', workbook.nsheets)

结果：

execfile(filename, namespace)

  File "E:\python\program\rdxls.py", line 14, in <module>

    workbook = open_workbook(input_file)

  File "C:\Python27\lib\site-packages\xlrd-1.2.0-py2.7.egg\xlrd\__init__.py", line 111, in open_workbook

    with open(filename, "rb") as f:

IOError: [Errno 22] invalid mode ('rb') or filename: 'e:\\python\trade.xls'

提示路径出错，怎么修改，请大神指点。Spyder(phthon 2.7)这个版本，默认路径安装。 QQ:804876498