Import error Openpyxl

[Atri Mahapatra]

I have  installed openpyxl  using  both cmd command and also by downloading from the  openpyxl site and both time I got the following message when I tried to import openpyxl:

Traceback (most recent call last):
  File "<pyshell#0>", line 1, in <module>
    import openpyxl
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\__init__.py", line 29, in <module>
    from openpyxl.workbook import Workbook
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\workbook\__init__.py", line 5, in <module>
    from .workbook import Workbook
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\workbook\workbook.py", line 8, in <module>
    from openpyxl.worksheet import Worksheet
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\worksheet\__init__.py", line 4, in <module>
    from .worksheet import Worksheet
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\worksheet\worksheet.py", line 34, in <module>
    from openpyxl.cell import Cell
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\cell\__init__.py", line 4, in <module>
    from .cell import Cell, WriteOnlyCell
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\cell\cell.py", line 30, in <module>
    from openpyxl.utils.datetime  import (
  File "C:\Users\atri.mahapatra\AppData\Local\Programs\Python\Python35\lib\site-packages\openpyxl\utils\datetime.py", line 13, in <module>
    from jdcal import (
ImportError: No module named 'jdcal'

Can anyone please suggest the reason?

Thanks,

atri

[Thomas Nygårds]

jdcal is a prerequisite for running openpyxl.

You can get it from here.
https://pypi.python.org/pypi/jdcal
or with

pip install jdcal

You might also need to install:
et_xmlfile.py
https://pypi.python.org/pypi/et_xmlfile


Regards
Thomas

[Charlie Clark]

Am .08.2016, 09:30 Uhr, schrieb Thomas Nygårds <thomas...@gmail.com>:

> jdcal is a prerequisite for running openpyxl.

And will be installed automatically if openpyxl is installed correctly.

Charlie
--
Charlie Clark
Managing Director
Clark Consulting & Research
German Office
Kronenstr. 27a
Düsseldorf
D- 40217
Tel: +49-211-600-3657
Mobile: +49-178-782-6226