No module named 'openpyxl' - Python 3.4 -

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 "<pyshell#0>", line 1, in <module>
from openpyxl import Workbook
ImportError: No module named 'openpyxl'

I am using Python 3.4 and Ubuntu 14.04, 32-bit OS type

Answer 1

You have to install it explixitly using the python package manager as

1. pip install openpyxl for Python 2
2. pip3 install openpyxl for Python 3

Answer 2

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.

Answer 3

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

conda install openpyxl

Answer 4

@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