【python 问题解决】 ---- ImportError: Missing optional dependency ‘xlrd‘. Install xlrd ＞= 1.0.0

Traceback (most recent call last):
  File "main.py", line 25, in <module>
    result = pd.read_excel('./pdfdata1.xlsx')
  File "D:\Python\lib\site-packages\pandas\util\_decorators.py", line 296, in wrapper
    return func(*args, **kwargs)
  File "D:\Python\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
    io = ExcelFile(io, engine=engine)
  File "D:\Python\lib\site-packages\pandas\io\excel\_base.py", line 867, in __init__
    self._reader = self._engines[engine](self._io)
  File "D:\Python\lib\site-packages\pandas\io\excel\_xlrd.py", line 21, in __init__
    import_optional_dependency("xlrd", extra=err_msg)
  File "D:\Python\lib\site-packages\pandas\compat\_optional.py", line 110, in import_optional_dependency
    raise ImportError(msg) from None
ImportError: Missing optional dependency 'xlrd'. Install xlrd >= 1.0.0 for Excel support Use pip or conda to install xlrd.

pip install xlrd

pip install openpyxl

result = pd.read_excel('./pdfdata1.xlsx', engine='openpyxl')