Openpyxl缺少“jdcal”

Question

我试图安装openpyxl模块，但在安装过程中，JDcall显示了一些错误。然后，当我试图导入它时，我会得到以下错误：

 Traceback (most recent call last):
  File "C:\Andrzej\workspace\sandbox\sandbox.py", line 7, in <module>
    import openpyxl 

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\__init__.py", line 29, in <module>
    from openpyxl.workbook import Workbook

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\workbook\__init__.py", line 25, in <module>
    from .workbook import *

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\workbook\workbook.py", line 35, in <module>
    from openpyxl.worksheet import Worksheet

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\worksheet\__init__.py", line 25, in <module>
    from .worksheet import *

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\worksheet\worksheet.py", line 35, in <module>
    import openpyxl.cell

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\cell\__init__.py", line 25, in <module>
    from .cell import *

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\cell\cell.py", line 47, in <module>
    from openpyxl.date_time import (

  File "C:\Python34\lib\site-packages\openpyxl-2.0.5-py3.4.egg\openpyxl\date_time.py", line 34, in <module>
    from jdcal import (

ImportError: No module named 'jdcal'

我在Python3.4和3.3中遇到了同样的问题，我如何解决它？

Answer 1

您应该单独安装jdcal。在此之后，安装Openpyxl。我也面临着同样的问题--在做完这件事后，它得到了解决。

Answer 2

在我从\path\to\pythonxx\Lib\site-packages\jdcal-1.4.1\下载了jdcal-x.tar.gz并将其解压缩到\path\ to \pythonxx\Lib\site之后，为了工作，我不得不将jdcal.py文件从https://pypi.org/project/jdcal/#files复制到\path\到\pythonxx\Lib\site。

Answer 3

jdcal是openpyxl所需的库，但应该自动安装。你是如何安装openpyxl的？