Openpyxl is missing "jdcal"

Question

I tried to install the openpyxl module, but during the installation it found some errors with JDcall . When I try to import it, I get this error:

  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' 

I get the same problem for Python 3.4 and 3.3, how can I solve it?

Answer 1

You must install jdcal separately. After that install Openpyxl . I ran into the same problem - after that it was resolved

Answer 2

jdcal is the library needed by openpyxl, but should be installed automatically. How do you install openpyxl?

Answer 3

I managed to get openpyxl by removing openpyxl , jdcall and et-xmlfile , then reinstalling all three and then updating all three.

Not sure why it works and error messages still exist, but I was able to successfully import openpyxl and create a book.

Answer 4

After I downloaded jdcal-xxxtar.gz from https://pypi.org/project/jdcal/#files and unzipped it in \ path \ to \ pythonxx \ Lib \ site-packages \, I had to copy the jdcal file. py from \ path \ to \ pythonxx \ Lib \ site-packages \ jdcal-1.4.1 \ to \ path \ to \ pythonxx \ Lib \ site-packages \ to work.