CODEWITHSUNDEEP
pythonexcelpython-3.xopenpyxl
Maarten
Maarten

Reputation: 41

Openpyxl not found in Pycharm

I am new to programming Python using Pycharm. I would like to access openpyxl (which I installed) but get the following error message:

Traceback (most recent call last):
  File "<input>", line 1, in <module>
  File "D:\PyCharm\PyCharm Community Edition 
2017.3.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 20, in 
do_import
    module = self._system_import(name, *args, **kwargs)
ModuleNotFoundError: No module named 'openpyxl'

This is probably a very simple problem but I just don't know how to proceed. Thanks in advance for your help.

Upvotes: 4

Views: 27979

Answers (4)

Shahidul Islam Molla
Shahidul Islam Molla

Reputation: 640

  1. Go File->settings->project Interpreter enter image description here

2. search for openpyxl enter image description here

3. Then click Install package.

Upvotes: 0

Mok Zhang Jing
Mok Zhang Jing

Reputation: 1

go to terminal and type "pip install openpyxl"

Upvotes: 0

Leo AS
Leo AS

Reputation: 31

Exactly how user5777975 explained however on some systems "Project Interpreter" is named "Python Interpreter" and the interface is slightly different.

So:

In the pycharm, go to File->settings->Python Interpreter Then click the + button ion the top left of the table of installed packages, you will get pop up window to install packages. Then search for openpyxl and you will get the latest package (default option). Then click Install package to install it. You will get notification if successful.

Upvotes: 3

user5777975
user5777975

Reputation:

In the pycharm, go to File->settings->project Interpreter Then click the right top corner + button you will get pop up window to install packages. Then search for openpyxl you will get the latest package. Then click Install package to install it.

Upvotes: 14

Related Questions