You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Python读取Excel遇openpyxl版本识别错误,求解决方案

排查ImportError: Can't determine version for openpyxl错误

我正在编写Python代码访问Excel文件,使用的代码如下:

from pandas import *
from openpyxl import *


print("Wpisz slowo ktore chcesz usunac:")  
Szukaj = str(input(""))
xlsx = ExcelFile('C:/Users/krzys/Desktop/Python/test.xlsx')
File = xlsx.parse(xlsx.sheet_names[0])
print(File.to_dict())

已通过pip安装pandas(版本1.5.1)和openpyxl(版本3.0.10),但运行代码时抛出ImportError: Can't determine version for openpyxl异常,错误栈信息如下:

Traceback (most recent call last):
  File "c:\Users\krzys\Desktop\Python\Drafts and Tests\xml.py", line 2, in <module>
    from openpyxl import *
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\__init__.py", line 6, in <module>
    from openpyxl.workbook import Workbook
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\workbook\__init__.py", line 4, in <module>
    from .workbook import Workbook
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\workbook\workbook.py", line 7, in <module>
    from openpyxl.worksheet.worksheet import Worksheet
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\worksheet\worksheet.py", line 25, in <module>
    from openpyxl.cell import Cell, MergedCell
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\cell\__init__.py", line 3, in <module>
    from .cell import Cell, WriteOnlyCell, MergedCell
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\cell\cell.py", line 27, in <module>
    from openpyxl.styles import numbers, is_date_format
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\styles\__init__.py", line 4, in <module>
    from .alignment import Alignment
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\styles\alignment.py", line 5, in <module>
    from openpyxl.descriptors import Bool, MinMax, Min, Alias, NoneSet
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\descriptors\__init__.py", line 4, in <module>
    from .sequence import Sequence
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\descriptors\sequence.py", line 4, in <module>
    from openpyxl.xml.functions import Element
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\xml\functions.py", line 28, in <module>
    from xml.etree.ElementTree import (
  File "c:\Users\krzys\Desktop\Python\Drafts and Tests\xml.py", line 7, in <module>
    xlsx = ExcelFile('C:/Users/krzys/Desktop/Python/test.xlsx')
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\pandas\io\excel\_base.py", line 1695, in __init__
    self._reader = self._engines[engine](self._io, storage_options=storage_options)
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\pandas\io\excel\_openpyxl.py", line 556, in __init__
    import_optional_dependency("openpyxl")
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\pandas\compat\_optional.py", line 157, in import_optional_dependency
    version = get_version(module_to_get)
  File "C:\Users\krzys\AppData\Local\Programs\Python\Python310\lib\site-packages\pandas\compat\_optional.py", line 83, in get_version
    raise ImportError(f"Can't determine version for {module.__name__}")
ImportError: Can't determine version for openpyxl

已尝试谷歌搜索解决方案、使用conda安装、调整PATH、重装openpyxl等方法,但问题仍未解决,恳请协助排查该错误。


内容的提问来源于stack exchange,提问作者Krzysztof Galiczowski

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.08.14 23:35:21