无法正确导入openpyxl

Question

嘿，我是编程新手。当我尝试将openpyxl模块导入Python时，我得到了错误：

Traceback (most recent call last):

File "X:\*filepath*\*filename*.py", line 2, in <module>
    import openpyxl

  File "C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\__init__.py", line 27, in <module>
    from openpyxl.workbook import Workbook

  File "C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\workbook\__init__.py", line 25, in <module>
    from .workbook import *

  File "C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\workbook\workbook.py", line 15, in <module>
    from openpyxl.worksheet import Worksheet

  File "C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\worksheet\__init__.py", line 25, in <module>
    from .worksheet import *

  File "C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\worksheet\worksheet.py", line 43, in <module>
    from openpyxl.formatting import ConditionalFormatting

  File "C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\formatting\__init__.py", line 7, in <module>
    from .rules import CellIsRule, ColorScaleRule, FormatRule, FormulaRule

  File "C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\site-packages\openpyxl\formatting\rules.py", line 5, in <module>
    from collections import Mapping

ImportError: cannot import name 'Mapping' from 'collections' (C:\Users\*User Name*\AppData\Local\Programs\Python\Python310\lib\collections\__init__.py)

我已经使用终端安装了openpyxl。我读了其他的帖子，但都无济于事。

Answer 1

你在你的代码中写道：

openpyxl import workbook

取而代之是使用：

openpyxl import Workbook