Page 1 of 1

No module named openpyxl

Posted: Wed Sep 20, 2017 1:11 pm
by gni_support
Cannot enable plugin GniPlannerFTTH, because occurs an error "No module named openpyxl".

Re: No module named openpyxl

Posted: Wed Sep 20, 2017 1:14 pm
by gni_support
Solution Ubuntu:

Run this command in terminal:
sudo apt-get install python-openpyxl
or
pip install openpyxl

Solution Windows:

Install openpyxl python library (https://openpyxl.readthedocs.io/en/default/).
Locate "bin" folder in your QGIS installation folder (probably "C:\Program Files\QGIS 2.18\bin") and run these commands in windows command line as administrator:
python-qgis.bat -m pip install setuptools (if setuptools are not installed)
python-qgis.bat -m pip install openpyxl

Re: No module named openpyxl

Posted: Mon Jan 01, 2018 8:49 pm
by Michael
Hello

I have got a similar problem: First, there was the same situation as explained above ("No module named openpyxl").
I tryed to solve the ploblem by following the desciption above (for Windows).

Now I can not enable plugin GniPlannerFTTH, because occurs an error "cannot import name LXML ".

I am grateful for your help.

Re: No module named openpyxl

Posted: Thu Jan 04, 2018 9:00 am
by gni_support
Mon Jan 01, 2018 8:49 pmMichael wrote:

I have got a similar problem: First, there was the same situation as explained above ("No module named openpyxl").
I tryed to solve the ploblem by following the desciption above (for Windows).

Now I can not enable plugin GniPlannerFTTH, because occurs an error "cannot import name LXML ".
Hello,

Try running these commands:

python-qgis.bat -m pip install openpyxl
python-qgis.bat -m pip install lxml

Re: No module named openpyxl

Posted: Mon Mar 26, 2018 11:56 am
by akhil.chibber
Wed Sep 20, 2017 1:14 pmgni_support wrote:
Solution Ubuntu:

Run this command in terminal:
sudo apt-get install python-openpyxl
or
pip install openpyxl

Solution Windows:

Install openpyxl python library (https://openpyxl.readthedocs.io/en/default/).
Locate "bin" folder in your QGIS installation folder (probably "C:\Program Files\QGIS 2.18\bin") and run these commands in windows command line as administrator:
python-qgis.bat -m pip install setuptools (if setuptools are not installed)
python-qgis.bat -m pip install openpyxl




CAN YOU PLEASE ME OUT REGARDING WHERE WE HAVE TO TYPE THE COMMAND
python-qgis.bat -m pip install setuptools (if setuptools are not installed)
python-qgis.bat -m pip install openpyxl
???????????
BECAUSE CMD IS NOT ABLE TO READ THE ABOVE COMMAND

Re: No module named openpyxl

Posted: Wed Feb 27, 2019 10:09 am
by TheoA
Hi,

I have installed the package using the instructions in the guide and have placed the python folder within the .qgis2 folder on the drive. However, when I try to download the report, I receive an error: Missing library - No module named openpyxl

Could you please let me know why does this error appear?

Thanks in advance,

T

Re: No module named openpyxl

Posted: Thu Oct 15, 2020 6:45 am
by jkowalsky
Hi,
I have the same problem. How to solve the problem it?
Thanks in advance.

Re: No module named openpyxl

Posted: Mon Feb 08, 2021 1:34 pm
by gni_support
Okay, so i've problably found solution to this problem...at least for windows version:
How to do it, step by step:

1.Open CMD and type: cd "(your location of qgis2.18 bin folder) ...example: cd "C:\Program Files\QGIS 2.18
2. Open your qgis2.18 bin folder, and look for python-qgis-(something).bat .... in my case it was python-qgis-ltr.bat
3. Now after you set your path into CMD type comands:

python-qgis-ltr.bat -m pip install setuptools (if setuptools are not installed) (Then press enter, it should run/install) .......after that type:

python-qgis-ltr.bat -m pip install openpyxl

4. Open qgis...

If it doesn't work, you probably didn't instal "pip" correctly