Openpyxl Library - Jdcal Error

I'm trying to work on some excel files, I decided to use openpyxl library. I've copied the openpyxl folder to /Lib/ and trying to do the import command on some sample code, and all

Solution 1:

openpyxl module has 2 dependent modules : 1. jdcal 2. et_xmlfile

I was able to install openpyxl module and this is what I did :

1. Downloaded the openpyxl,jdcal and et_xmlfile from https://pypi.python.org/pypi and saved jdcal-1.0.tar.gz, et_xmlfile-1.0.0.tar.gz,openpyxl-2.3.0-b2.tar.gz in a local folder in my system.

2. Then I ran the commands in the following order :

   pip install jdcal-1.0.tar.gz
   pip install et_xmlfile-1.0.0.tar.gz
   pip install openpyxl-2.3.0-b2.tar.gz
   

openpyxl got successfully after this.

Solution 2:

Actually openpyxl depends upon jdcal & et_xmlfile. You first require to install these two packages. I have managed to run openpyxl by downloading and giving refrencing some thing like this:

#For Writing in Excel File
import sys
#For openpyxl-2.4.0 Python Package you should need to have et_xmlfile and jdcal package
sys.path.append("D:\et_xmlfile-1.0.1")
sys.path.append("D:\jdcal-1.3")
sys.path.append('D:\openpyxl-2.4.0')

import openpyxl

Solution 3:

I was same problem. I solved it :) . if you have pip3 or other you can simple download and install from your terminal:-

sudo pip3 pip3 install jdcal
sudo pip3 install et_xmlfile