No module named openpyxl

[gni_support]

Cannot enable plugin GniPlannerFTTH, because occurs an error "No module named openpyxl".

[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

[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.

[gni_support]

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

[akhil.chibber]

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

[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

[jkowalsky]

Hi,
I have the same problem. How to solve the problem it?
Thanks in advance.

[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