解决：module 'xlrd' has no attribute 'open_workbook'的报错

D:\python\p\python.exe F:/xlrd/xlrd.py
Traceback (most recent call last):
  File "F:/xlrd/xlrd.py", line 38, in <module>
    read_excel()
  File "F:/xlrd/xlrd.py", line 9, in read_excel
    workbook=xlrd.open_workbook(r'F:\xlrd\学生表.xlsx')
AttributeError: module 'xlrd' has no attribute 'open_workbook'

Process finished with exit code 1

出现这种错误，解决办法为：

data=xlrd.open_workbook('results.xls') 失败

报错：AttributeError: module 'xlrd' has no attribute 'open_workbook'

我的原因：发现创建的py文件名叫 xlrd.py ,这样导致在文件中找open_workbook方法，改文件名成xlrdtest.py,成功!