Cannot install openpyxl

Python Help
1

Hi, I’m trying to install openpyxl from pypi.org for a project with Excel files. I’ve typed pip install openpyxl in the terminal and installed it sucessfully. I have then import it with import openpyxl as xl. But when I run it I get the following error:

Traceback (most recent call last):
File “F:\backup.desktop\Bogdan\Python\automation xsl.py”, line 3, in
import openpyxl as xl
ModuleNotFoundError: No module named ‘openpyxl’

Process finished with exit code 1

I checked the External Libraries\Python 3.10\ site packages, where it should be and indeed it’s not there. But if I try to install it again I get the following message on the terminal:

PS C:\Users\Ioana\PycharmProjects\pythonProject> pip install openpyxl
Requirement already satisfied: openpyxl in c:\users\ioana\appdata\local\programs\python\python310\lib\site-packages (3.0.10)
Requirement already satisfied: et-xmlfile in c:\users\ioana\appdata\local\programs\python\python310\lib\site-packages (from openpyxl) (1.1.0)

It says it’s already there. Any ideas?

2

Does the version of pip you are running match the version of python you are running?
Suggest you avoid using pip instead do this:

py -3 -m pip install openpyxl

Then try running your program.

3

Python is 3.10 and pip is 3.0.10

I have uninstalled the openpyxl and then instaleed it with your method. Still doesn’t work

4

That is a very old version of pip here is what I get when I using openpyxl.
You can see that it just works. Check that you see the versions that are like what I have.

: 18:00:25.83 C:\Users\barry> py -3
Python 3.10.3 (tags/v3.10.3:a342a49, Mar 16 2022, 13:07:40) [MSC v.1929 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> impoer openpyxl
  File "<stdin>", line 1
    impoer openpyxl
           ^^^^^^^^
SyntaxError: invalid syntax
>>> ^Z


: 18:00:42.67 C:\Users\barry> py -3 -m pip --version
pip 22.0.4 from C:\Program Files\Python310\lib\site-packages\pip (python 3.10)

: 18:00:48.94 C:\Users\barry> py -3 -m pip install --user openpyxl
Collecting openpyxl
  Downloading openpyxl-3.0.10-py2.py3-none-any.whl (242 kB)
     ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 242.1/242.1 KB 7.2 MB/s eta 0:00:00
Collecting et-xmlfile
  Downloading et_xmlfile-1.1.0-py3-none-any.whl (4.7 kB)
Installing collected packages: et-xmlfile, openpyxl
Successfully installed et-xmlfile-1.1.0 openpyxl-3.0.10
WARNING: You are using pip version 22.0.4; however, version 22.2.2 is available.
You should consider upgrading via the 'C:\Program Files\Python310\python.exe -m pip install --upgrade pip' command.

: 18:01:09.31 C:\Users\barry> py -3
Python 3.10.3 (tags/v3.10.3:a342a49, Mar 16 2022, 13:07:40) [MSC v.1929 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import openpyxl
>>> ^Z
5

Guessing you got this sorted by now. However, for anyone else facing the same issue, here’s what worked for me…

  1. In a terminal type ‘python’ (opens Python REPL - prompt will be ‘>>>’)
  2. At >>> prompt, type ‘import openpyxl’ (without the quotes :slight_smile: ). You should get no output response other than a new line.

That’s it. Cheers