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
相关产品推荐
相关产品推荐

