No module named openpyxl питон

How to fix ModuleNotFoundError: No module named ‘openpyxl’

One error you might encounter when working with Excel files in Python is:

This error occurs when Python can’t find the openpyxl library in the current environment.

In this tutorial, I will show you an example that causes this error and how to fix it in practice.

How to reproduce the error

Suppose you want to use the openpyxl module to create an Excel Workbook and a Sheet as follows:

But you get the following error when running the code:

To my knowledge, the ModuleNotFoundError happens when Python can’t find the module you’re trying to import.

The openpyxl module is not bundled with Python, so you need to install it first.

How to fix this error

To resolve this error, you need to install the openpyxl library using the pip install command:

  Once the module is installed, you should be able to run the code that imports openpyxl without receiving the error.

Install commands for other environments

The install command might differ depending on what environment you used to run the Python code.

Here’s a list of common install commands in popular Python environments to install the openpyxl module:

Once the module is installed, you should be able to run the code without receiving this error.

Other common causes for this error

If you still see the error even after installing the module, it means that the openpyxl module can’t be found in your Python environment.

1. You may have multiple versions of Python installed on your system, and you are using a different version of Python than the one where openpyxl is installed.
2. You might have openpyxl installed in a virtual environment, and you are not activating the virtual environment before running your code.
3. Your IDE uses a different version of Python from the one that has openpyxl
4. The package is not installed in PyCharm

Let’s see how to fix these errors in practice.

1. You have multiple versions of Python

If you have multiple versions of Python installed on your system, you need to make sure that you are using the specific version where the openpyxl module is available.

You can test this by running the which -a python or which -a python3 command from the terminal:

 In the example above, there are two versions of Python installed on /opt/homebrew/bin/python3 and /usr/bin/python3 .

Suppose you run the following steps in your project:

1. Install openpyxl with pip using /usr/bin/ Python version
2. Install Python using Homebrew, you have Python in /opt/homebrew/
3. Then you run import openpyxl in your code

The steps above will cause the error because openpyxl is installed in /usr/bin/ , and your code is probably executed using Python from /opt/homebrew/ path.

To solve this error, you need to run the pip install openpyxl command again so that openpyxl is installed and accessible by the active Python version.

2. Python virtual environment is active

Another scenario that could cause this error is you may have openpyxl installed in a virtual environment.

Python venv package allows you to create a virtual environment where you can install different versions of packages required by your project.

If you are installing openpyxl inside a virtual environment, then the module won’t be accessible outside of that environment.

You can see if a virtual environment is active or not by looking at your prompt in the terminal.

When a virtual environment is active, the name of that environment will be shown inside parentheses as shown below:

In the picture above, the name of the virtual environment (demoenv) appears, indicating that the virtual environment is currently active.

If you run pip install while the virtual environment is active, then the package is installed only for that environment

Likewise, any package installed outside of that virtual environment won’t be accessible from the virtual environment. The solution is to run the pip install command on the environment you want to use.

If you want to install openpyxl globally, then turn off the virtual environment by running the deactivate command before running the pip install command.

3. IDE using a different Python version

Finally, the IDE from where you run your Python code may use a different Python version when you have multiple versions installed.

For example, you can check the Python interpreter used in VSCode by opening the command palette ( CTRL + Shift + P for Windows and ⌘ + Shift + P for Mac) then run the Python: Select Interpreter command.

You should see all available Python versions listed as follows:

You need to use the same version where you installed openpyxl so that the module can be found when you run the code from VSCode.

Once done, you should be able to import openpyxl without receiving any errors.

4. You see this error in PyCharm

If you’re using PyCharm as your IDE, then this error might occur because the package is not installed in the Python interpreter used by PyCharm.

This is because PyCharm creates a new virtual environment for each project you create using the IDE.

To resolve this error, you can install the package using PyCharm’s terminal.

For more information, you can see the guide to install and uninstall packages in PyCharm.

Conclusion

In summary, the ModuleNotFoundError: No module named ‘openpyxl’ occurs when the openpyxl library is not installed in your Python environment. To resolve this error, you need to run the pip install openpyxl command.

If you already have the module installed, make sure you are using the correct version of Python, check if the virtual environment is active if you have one, and check for the Python version used by your IDE.

By following these steps, you should be able to import the openpyxl module in your code successfully.

I hope you find this tutorial helpful. Until next time! 👋

Take your skills to the next level ⚡️

I’m sending out an occasional email with the latest tutorials on programming, web development, and statistics. Drop your email in the box below and I’ll send new stuff straight into your inbox!

About

Hello! This website is dedicated to help you learn tech and data science skills with its step-by-step, beginner-friendly tutorials.
Learn statistics, JavaScript and other programming languages using clear examples written for people.

Search

Type the keyword below and hit enter

Источник

Python-сообщество

• Начало
• » Python для новичков
• » Не могу запустить openpyxl

#1 Фев. 14, 2017 20:48:56

Не могу запустить openpyxl

Добрый вечер, всем!
Надеюсь, поможете

Скачал книгу Автоматизация рутинных задач с помощью Python
Там нужно запустить openpyxl

Traceback (most recent call last):
File “”, line 1, in
import openpyxl
ImportError: No module named openpyxl

CMD показывает, что python 27 установлен и когда пишу pip install openpyxl — пишет, что есть такой в папке Anaconda…

В Path, вроде, тоже все прописал.

Чего не хватает, не могу понять, где недочет

#2 Фев. 14, 2017 22:01:33

Не могу запустить openpyxl

1. Запускайте интерпретатор не Python 2.7, а Python 3.5, который по умолчанию должен быть инсталлирован в папку C:\Python35

2. Путь к python.exe для Python 3.5 (C:\Python35) должен быть прописан в PATH, а у вас, как видно на скриншоте, прописан только для Python 2.7 (C:\Python27).

3. Модуль openpyxl, возможно, требуется обновить до последней версии. Это делается командой pip install -U openpyxl

4. На вашем скриншоте в переменной PATH заметна явная ошибка — написано C:\Python35\Sripts, должно быть C:\Python35\Scripts.

Отредактировано old_monty (Фев. 14, 2017 22:26:47)

#3 Фев. 15, 2017 00:35:25

Не могу запустить openpyxl

Вроде, ошибок не возникает, спасибо!

>>> import openpyxl
>>> wb = openpyxl.load_workbook(‘example.xslx’)

Traceback (most recent call last):
File “”, line 1, in
wb = openpyxl.load_workbook(‘example.xslx’)
File “C:\Users\Anton\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\excel.py”, line 152, in load_workbook
archive = _validate_archive(filename)
File “C:\Users\Anton\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\excel.py”, line 115, in _validate_archive
archive = ZipFile(filename, ‘r’, ZIP_DEFLATED)
File “C:\Users\Anton\AppData\Local\Programs\Python\Python36\lib\zipfile.py”, line 1082, in __init__
self.fp = io.open(file, filemode)
FileNotFoundError: No such file or directory: ‘example.xslx’
>>>

#4 Фев. 15, 2017 04:54:22

Vigi От: Курья, Алтай Зарегистрирован: 2015-02-07 Сообщения: 144 Репутация: 8 Профиль Отправить e-mail

Не могу запустить openpyxl

Отредактировано Vigi (Фев. 15, 2017 04:55:16)

#5 Фев. 15, 2017 15:59:52

Не могу запустить openpyxl

Antonpython
При вызове openpyxl.load_workbook(‘example.xslx’) указывайте полный путь к файлу example.xlsx, как уже вам правильно советовал Vigi. Либо скопируйте файл example.xslx в текущий рабочий каталог. Узнать, какой каталог является текущим рабочим каталогом можно с помощью функции getcwd() из модуля os. Или можно не выходя из Python перейти в тот каталог, где фактически находится example.xlsx, с помощью функции chdir() того же модуля. У вас должно получиться примерно так:

>>> import os >>> os.getcwd() 'C:\\Users\\Anton' >>> os.chdir(r"C:\users\Anton\Desktop") >>> os.getcwd() 'C:\\users\\Anton\\Desktop' 

#6 Фев. 15, 2017 20:50:12

Не могу запустить openpyxl

>>> import openpyxl
>>> os.chdir(r“C:\Users\Anton\Desktop\Python”)
>>> wb = openpyxl.load_workbook(‘example.xslx’)
Traceback (most recent call last):
File “”, line 1, in
wb = openpyxl.load_workbook(‘example.xslx’)
File “C:\Users\Anton\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\excel.py”, line 152, in load_workbook
archive = _validate_archive(filename)
File “C:\Users\Anton\AppData\Local\Programs\Python\Python36\lib\site-packages\openpyxl\reader\excel.py”, line 115, in _validate_archive
archive = ZipFile(filename, ‘r’, ZIP_DEFLATED)
File “C:\Users\Anton\AppData\Local\Programs\Python\Python36\lib\zipfile.py”, line 1082, in __init__
self.fp = io.open(file, filemode)
FileNotFoundError: No such file or directory: ‘example.xslx’
>>>

Поменял директорию
Добавил туда example.xslx
Не взлетело

Подскажите, что сделать, чтобы все открылось?)

Отредактировано Antonpython (Фев. 15, 2017 20:50:41)

#7 Фев. 15, 2017 21:12:40

Не могу запустить openpyxl

Странно. Я специально проделал все эти действия в винде, и у меня сразу же все взлетело.
Может, надо наоборот, сначала скопировать файл example.xlsx в нужную директорию, потом переходить в нее, когда файл в ней уже точно есть. Или вообще никуда не переходить, просто положить файл в свой текущий рабочий каталог, который определяется через os.getcwd(), и находясь в нем, запускать Python.

Поправка: имя файла у меня в предыдущем сообщении было указано с ошибкой, а вы просто эту ошибку повторили при наборе команды. Не example.xslx он называется, а example.xlsx

Отредактировано old_monty (Фев. 15, 2017 21:31:46)

#8 Фев. 16, 2017 19:42:49

Не могу запустить openpyxl

Спасибо огромное, у меня зрение прост садится) Смешная ситуация

Взлетело.
Спасибо!
Двигаюсь дальше.

Источник