python之不能用 pandas read_excel

我正在学习 Pandas 库。在 Python3 中，但我有一个大问题。当我使用命令读取 excel 时出现错误。

import pandas as pd 
 
df = pd.read_excel(r'D:\PythonProjects\stocks.xlsx',sheetname=0) 

错误看起来像这样:

C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\util\_decorators.py:118: FutureWarning: The `sheetname` keyword is deprecated, use `sheet_name` instead 
  return func(*args, **kwargs) 
Traceback (most recent call last): 
  File "D:/MyPythonProjects/urlib.py", line 4, in <module> 
    df = pd.read_excel(r'D:\MyPythonProjects\NewL\stocksa.xlsx',sheetname=0 ) 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\util\_decorators.py", line 118, in wrapper 
    return func(*args, **kwargs) 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\io\excel.py", line 230, in read_excel 
    io = ExcelFile(io, engine=engine) 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\pandas\io\excel.py", line 294, in __init__ 
    self.book = xlrd.open_workbook(self._io) 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\xlrd\__init__.py", line 141, in open_workbook 
    ragged_rows=ragged_rows, 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\xlrd\xlsx.py", line 808, in open_workbook_2007_xml 
    x12book.process_stream(zflo, 'Workbook') 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\xlrd\xlsx.py", line 265, in process_stream 
    meth(self, elem) 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\xlrd\xlsx.py", line 392, in do_sheet 
    sheet = Sheet(bk, position=None, name=name, number=sheetx) 
  File "C:\Users\Kuba\AppData\Local\Programs\Python\Python36\lib\site-packages\xlrd\sheet.py", line 326, in __init__ 
    self.extract_formulas = book.extract_formulas 
AttributeError: 'Book' object has no attribute 'extract_formulas' 

我不知道怎么解决。我已经尝试重新安装 pandas、xlrd，但仍然出现相同的错误。你能给我一个如何修复这个问题的建议吗？

请您参考如下方法:

当你这样做时会发生什么

pd.ExcelFile(filename) 

如果这会引发相同的错误，则可能是由于 xlrd 的版本所致。我无法从 xlrd 的最新版本的 Book 对象中找到 extract_formula。 [source]