python-3.x 导入错误：Pandas需要'3.0.7'或更新版本的'openpyxl'(当前安装的是'3.0.5'版本)

cpjpxq1n 于 2022-12-01 发布在 Python

关注(0)|答案(1)|浏览(1651)

我有一个奇怪的问题，导致了标题中的msg，导致了下面的错误报告。事实是-我有（在Linux上）python 3.9.15，Pandas 1.5.2，openpyxl 3.0.10。我不使用venv，我使用Wing进行编辑，但我不从它运行脚本，我在/usr/lib 64/python3.9/site-packages/中找不到任何其他版本的openpyxl。怎么了？我甚至卸载并重新安装了panda和openpyxl -没有效果。

File "./elektreiba-00-02.py", line 140, in <module> main(sys.argv[1:])
  File "./elektreiba-00-02.py", line 79, in main  df = pd.read_excel(infile, sheet_name=None)
  File "/usr/lib64/python3.9/site-packages/pandas/util/_decorators.py", line 211, in wrapper
    return func(*args, **kwargs)
  File "/usr/lib64/python3.9/site-packages/pandas/util/_decorators.py", line 331, in wrapper
    return func(*args, **kwargs)
  File "/usr/lib64/python3.9/site-packages/pandas/io/excel/_base.py", line 482, in read_excel
    io = ExcelFile(io, storage_options=storage_options, engine=engine)
  File "/usr/lib64/python3.9/site-packages/pandas/io/excel/_base.py", line 1695, in __init__
    self._reader = self._engines[engine](self._io, storage_options=storage_options)
  File "/usr/lib64/python3.9/site-packages/pandas/io/excel/_openpyxl.py", line 556, in __init__
    import_optional_dependency("openpyxl")
  File "/usr/lib64/python3.9/site-packages/pandas/compat/_optional.py", line 171, in import_optional_dependency
    raise ImportError(msg)
ImportError: Pandas requires version '3.0.7' or newer of 'openpyxl' (version '3.0.5' currently installed)

python-3.x

来源：https://stackoverflow.com/questions/74612873/importerror-pandas-requires-version-3-0-7-or-newer-of-openpyxl-version-3