使用Python 3.8.2并安装了openpyxl 3.0.3 (通过使用"pip install openpyxl“
尝试运行以下代码:https://automatetheboringstuff.com/chapter12/
尝试时:
“导入openpyxl”
我得到了一个错误:
"C:\Users\Lenovo\PycharmProjects\statsparser\venv\Scripts\python.exe C:/Users/Lenovo/PycharmProjects/statsparser/venv/excelprocessor.py
Traceback (most recent call last):
File "C:/Users/Lenovo/PycharmProjects/statsparser/venv/excelprocessor.py", line 1, in <module>
from openpyxl import Workbook
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\__init__.py", line 6, in <module>
from openpyxl.workbook import Workbook
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\workbook\__init__.py", line 4, in <module>
from .workbook import Workbook
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\workbook\workbook.py", line 7, in <module>
from openpyxl.worksheet.worksheet import Worksheet
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\worksheet\worksheet.py", line 24, in <module>
from openpyxl.cell import Cell, MergedCell
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\cell\__init__.py", line 3, in <module>
from .cell import Cell, WriteOnlyCell, MergedCell
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\cell\cell.py", line 27, in <module>
from openpyxl.styles import numbers, is_date_format
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\styles\__init__.py", line 4, in <module>
from .alignment import Alignment
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\styles\alignment.py", line 5, in <module>
from openpyxl.descriptors import Bool, MinMax, Min, Alias, NoneSet
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\descriptors\__init__.py", line 3, in <module>
from .base import *
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\descriptors\base.py", line 12, in <module>
from openpyxl.utils.datetime import from_ISO8601
File "C:\Users\Lenovo\PycharmProjects\statsparser\venv\openpyxl\utils\datetime.py", line 12, in <module>
from jdcal import (
ModuleNotFoundError: No module named 'jdcal'进程已完成,退出代码为% 1“
尝试时:
“从openpyxl导入工作簿”
得到相同的错误。
“从openpyxl.worksheet.worksheet导入工作表”
得到相同的错误
发布于 2020-04-06 23:46:16
其本质在于语句:ModuleNotFoundError: No module named 'jdcal'
按照以下答案安装jdcal:here
https://stackoverflow.com/questions/60839272
复制相似问题