Openpyxl not found in Pycharm

14,106

Solution 1

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.

Solution 2

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.

Share:
14,106

Related videos on Youtube

Maarten
Author by

Maarten

Updated on June 04, 2022

Comments

  • Maarten
    Maarten almost 2 years

    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.

  • Dabananda Mitra
    Dabananda Mitra about 3 years
    Thank you so much. Your answer solved my problem. Thank you again.