No module named openpyxl - Python 3 4 - Ubuntu

Question

I installed openpyxl with    pip install openpyxl   when I try the command  from openpyxl import Workbook   I get  Traceback  most recent call last    File   lt pyshell 0 gt    line 1  in  lt module gt  from openpyxl import Workbook ImportError  No module named  openpyxl    I am using Python 3 4 and Ubuntu 14 04  32-bit OS type

User · Answer

If you re using Python3  then install  python3 -m pip install --user xlsxwriter  This will run pip with the appropriate version of Python3  If you run bare pip3 and have many versions of Python install  it will still fail leading to more confusion  The --user flag will allow to install as a regular user and no require root

User · Answer

You have to install it explixitly using the python package manager as   pip install openpyxl for Python 2 pip3 install openpyxl for Python 3

User · Answer

I had the same problem solved using instead of pip install     sudo apt-get install python-openpyxl sudo apt-get install python3-openpyxl   The sudo command also works better for other packages

User · Answer

In order to keep track of dependency issues  I like to use the conda installer  which simply boils down to    conda install openpyxl

User · Answer

If you don t use conda  just use     pip install openpyxl   If you use conda  I d recommend    conda install -c anaconda openpyxl   instead of simply conda install openpyxl   Because there are issues right now with conda updating  see GitHub Issue  8842    this is being fixed and it should work again after the next release  conda 4 7 6

User · Answer

zetysz and  Manish already fixed the problem  I am just putting this in an answer for future reference    pip refers to Python 2 as a default in Ubuntu  this means that pip install x will install the module for Python 2 and not for 3 pip3 refers to Python 3  it will install the module for Python 3

User · Answer

I still was not able to import  openpyxl  after successfully installing it via both conda and pip  I discovered that it was installed in   usr lib python3 dist-packages   so this https   stackoverflow com a 59861933 10794682 worked for me  import sys  sys path append   usr lib python3 dist-packages    Hope this might be useful for others

[python] No module named 'openpyxl' - Python 3.4 - Ubuntu

Examples related to python

Examples related to ubuntu

Examples related to python-3.4

Examples related to openpyxl