ModuleNotFoundError: No module named ‘openpyxl’

In Python, ModuleNotFoundError: No module named ‘openpyxl’ error occurs if we try to import the ‘openpyxl‘ module without installing the package or if you have not installed it in the correct environment.

In this tutorial, let’s look at installing the openpyxl module correctly in different operating systems and solve ModuleNotFoundError: No module named ‘openpyxl’ error.  

What is ModuleNotFoundError: No module named ‘openpyxl’?

There are various reasons why we get the ModuleNotFoundError: No module named ‘openpyxl’ error

  • Trying to use the module- without installing the openpyxl package.
  • If the IDE is set to the incorrect version of the Python/Python interpreter.
  • You are using the virtual environment and the openpyxl module is not installed inside a virtual environment
  • Installing the openpyxl package in a different version of Python than the one which is used currently.
  • Declaring a variable name as the module name(openpyxl)

If you are getting an error installing pip, checkout pip: command not found to resolve the issue.

How to fix ModuleNotFoundError: No module named ‘openpyxl’?

openpyxl is not a built-in module (it doesn’t come with the default python installation) in Python; you need to install it explicitly using the pip installer and then use it.  

openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files. It was born from a lack of an existing library to read/write natively from Python in the Office Open XML format.

We can fix the error by installing the ‘openpyxl‘ module by running the pip install openpyxl command in your terminal/shell.

We can verify if the package is installed correctly by running the following command in the terminal/shell.

This will provide the details of the package installed, including the version number, license, and the path it is installed. If the module is not installed, you will get a warning message in the terminal stating WARNING: Package(s) not found: openpyxl.

pip show openpyxl

Output

Name: openpyxl
Version: 3.0.10
Summary: A Python library to read/write Excel 2010 xlsx/xlsm files
Home-page: https://openpyxl.readthedocs.io
Author: See AUTHORS
Author-email: charlie.clark@clark-consulting.eu
License: MIT
Location: c:\personal\ijs\python_samples\venv\lib\site-packages
Requires: et-xmlfile

Solution 1 – Installing and using the openpyxl module in a proper way

Based on the Python version and the operating system you are running, run the relevant command to install the openpyxl module.

# If you are using Python 2 (Windows)
pip install openpyxl

# if you are using Python 3 (Windows)
pip3 install openpyxl

# If the pip is not set as environment varibale PATH
python -m pip install openpyxl

# If you are using Python 2 (Linux)
sudo pip install openpyxl

# if you are using Python 3 (Linux)
sudo pip3 install openpyxl

# In case if you have to easy_install
sudo easy_install -U openpyxl

# On Centos
yum install openpyxl

# On Ubuntu
sudo apt-get install openpyxl

# If you are installing it in Anaconda 
conda install -c anaconda openpyxl

Once you have installed the openpyxl module, we can now import it inside our code and use it as shown below.

from openpyxl import Workbook
wb = Workbook()

# grab the active worksheet
ws = wb.active

# Data can be assigned directly to cells
ws['A1'] = 42

# Rows can also be appended
ws.append([1, 2, 3])

# Python types will automatically be converted
import datetime
ws['A2'] = datetime.datetime.now()

# Save the file
wb.save("sample.xlsx")

Solution 2 – Verify if the IDE is set to use the correct Python version

If you are still getting the same error even after installing the package, you can verify if the IDE you are using is configured with the correct version of the Python interpreter.

For Eg:- In the case of Visual Studio Code, we can set the Python version by pressing CTRL + Shift + Por ( + Shift + P on Mac) to open the command palette.

Once the command palette opens, select the Python interpreter and select the correct version of Python and also the virtual environment(if configured) as shown below.

Image 1

Python Interpreter

Solution 3 – Installing openpyxl inside the virtual environment

Many different IDEs like Jupyter Notebook, Spyder, Anaconda, or PyCharm often install their own virtual environment of Python to keep things clean and separated from your global Python.

If you are using VS Code, then you can also create a virtual environment, as shown below.

In the case of virtual environments, you need to ensure that the openpyxl module needs to be installed inside the virtual environment and not globally.

Step 1: Create a Virtual Environment. If you have already created a virtual environment, then proceed to step 2.

Step 2: Activate the Virtual Environment

Step 3: Install the required module using the pip install command

# Create a virtual Environment
py -3 -m venv venv

# Activate the virtual environment (windows command)
venv\Scripts\activate.bat

# Activate the virtual environment (windows powershell)
venv\Scripts\Activate.ps1

# Activate the virtual environment (Linux)
source venv/bin/activate

# Install openpyxl inside the virtual environment
pip install openpyxl

Solution 4 – Ensure that a module name is not declared name a variable name.

Last but not least, you may need to cross-check and ensure that you haven’t declared a variable with the same name as the module name.

You should check if you haven’t named any files as openpyxl.py as it may shadow the original openpyxl module.

If the issue is still not solved, you can try removing the package and installing it once again, restart the IDE, and check the paths to ensure that packages are installed in the correct environment path and Python version.

Conclusion

The ModuleNotFoundError: No module named ‘openpyxl’ error occurs when we try to import the ‘openpyxl‘ module without installing the package or if you have not installed it in the correct environment.

We can resolve the issue by installing the openpyxl module by running the pip install openpyxl command. Also, ensure that the module is installed in the proper environment in case you use any virtual environments, and the Python version is appropriately set in the IDE that you are running the code.

Leave a Reply

Your email address will not be published.

Sign Up for Our Newsletters

Subscribe to get notified of the latest articles. We will never spam you. Be a part of our ever-growing community.

You May Also Like
Python String Index()

Python String index()

Table of Contents Hide index() Syntaxindex() Parametersindex() Return ValueDifference between index() method and find() methodExample 1: Find the index of a string in PythonExample 2: If string is not found…
View Post
Python Bin()

Python bin()

Table of Contents Hide bin() Syntaxbin() Parametersbin() Return ValueExample 1: Convert integer to binary using bin() methodExample 2: TypeError: ‘float’ object cannot be interpreted as an integerExample 3: Convert an…
View Post
Python Ternary Operator

Python Ternary Operator

Python Ternary operators also called conditional expressions, are operators that evaluate something based on a binary condition. Ternary operators provide a shorthand way to write conditional statements, which makes the…
View Post
Python Complex()

Python complex()

Table of Contents Hide complex() Syntax complex() Parameterscomplex() Return ValueExample 1: How to create a complex number in Python?Example 2: TypeError while converting string with imaginary parameterExample 3: ValueError if string…
View Post