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