Python cannot import openpyxl

Question

I am running Windows 7 and using Python 2.7.

I have installed openpyxl using easy_install. It looks like the installation was successful. I changed the directory and fired up Python.

>>> import openpyxl >>>

So, this should mean that Python is able to find openpyxl. However, when I execute a simple test program excell_tutorial1.py and run it, I get the following:

Traceback (most recent call last): File "C:/Python27/playground/excell_tutorial1.py", line 7, in <module> from openpyxl import Workbook ImportError: No module named openpyxl

Very confusing! It could find it in prompt line but not in the program!

import os, sys the_module ="C:\\Python27\\Lib\\site-packages\\openpyxl-2.3.3-py2.7.egg\\openpyxl" if the_module not in sys.path: sys.path.append(the_module) if the_module in sys.path: print sys.path.index(the_module) print sys.path[18]

so, this gives me:

18 C:\Python27\Lib\site-packages\openpyxl-2.3.3-py2.7.egg\openpyxl

Anyone can think of what the problem might be?

Much appreciated

Did you start it with python excell_tutorial1.py or just excell_tutorial1.py from the command line i.e. via the association of the executable to the file extensions? — Mike Müller
– Mike Müller, Commented Jan 22, 2016 at 17:26
The problem is no more! And, I did not do anything. When I posted the question, for some reason PYTHONPATH was empty while sys.path was not and I could not write to PYTHONPATH. Then, all of a sudden this morning, everything worked. PYTHONPATH is no longer empty and the little post-install test program works. Thanks for taking the time to reply @MikeMüller — EarlyCoder
– EarlyCoder, Commented Jan 23, 2016 at 14:13
Maybe somehow you deleted all entries in PYTHONPATH by accident. Today, you opened a new shell (cmd window) and the PYTHONPATH was taken from your settings. — Mike Müller
– Mike Müller, Commented Jan 23, 2016 at 16:38

rainer · Accepted Answer · 2016-11-06 20:21:09Z

5

I had the same problem solved using instead of pip or easy install one of the following commands :

sudo apt-get install python-openpyxl sudo apt-get install python3-openpyxl

The sudo command also works better for other packages.

answered Nov 6, 2016 at 20:21

rainer

3,4315 gold badges39 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

PAX Over a year ago

Crazy that PIP isn't convenient for installation of Python modules...

Dan Over a year ago

Uhh what if sudo doesn't wanna work? It's "not a recognized command"

farisfath25 Over a year ago

@Dan I guess the answerer didn't pay attention much, actually the poster asked for Windows and 'sudo' is not a Windows command, it's a Linux's one.

Community · Accepted Answer · 2017-05-23 11:46:07Z

While not quite what you ran into here (since you state that you are using python 2.7), for those who run into this issue and are using python 3, you may be unintentionally installing to python 2 instead. To force the install to python 3 (instead of 2) use pip3 instead.

See this thread for more info: No module named 'openpyxl' - Python 3.4 - Ubuntu

Collin Stump · Accepted Answer · 2016-02-17 01:06:56Z

Try deleting all openpyxl material from C:\Python27\Lib\site-packages\

Once you do that try reinstalling it using pip. (This what worked for me)

Tshilidzi Mudau · Accepted Answer · 2017-03-02 08:46:29Z

At times this can be a simple permission issue. As it was in my case. I installed it in my local directory with my login.

python ./setup.py install

but some of the other user were not able to import the module. They were getting this error:

ImportError: No module named openpyxl

Hence I simply gave exe permission to 'others'

chmod -R 755

That solves the problem at least in my case.

Rohit Gawas · Accepted Answer · 2018-06-27 13:35:00Z

Go to the directory where pip is installed, for eg.C:\Python27\Scripts and open cmd (simply type cmd in address bar ). Now run the command "pip install openpyxl". It will install the package itself. Hope this will solve your problem.

RobC · Accepted Answer · 2019-09-11 11:30:41Z

1

Try this:

!pip install openpyxl

edited Sep 11, 2019 at 11:30

RobC

25.3k21 gold badges87 silver badges88 bronze badges

answered Sep 11, 2019 at 11:00

AYUSH KUMAR

112 bronze badges

1 Comment

Shanteshwar Inde Over a year ago

please use comment section for such short answers. Thanks!

patti_jane · Accepted Answer · 2020-04-15 20:15:34Z

I had the same issue on 3.8.2

I found out that python was installed in two locations on my machine (probably py and python, just a guess) Here:

C:\Users<userAccount>\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.8\LocalCache\local-packages\Python38

and Here:

C:\Python38

I deleted the one in my C drive and everything is working well now. I would double check to see where your packages are getting installed first, before deleting. Which ever one is being used, keep that one.

For this case, check to see where this package got installed:

C:\Users\<userAccount>\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.8\LocalCache\local-packages\Python38\site-packages\openpyxl

keep that directory.

Saalar · Accepted Answer · 2022-07-26 17:09:21Z

What worked for me was to open the terminal as an administrator, cd to the 'scripts' file of where python (different for each version) is stored, and then install using pip:

cd C:\Users\Salfa\AppData\Local\Programs\Python\Python39\Scripts

pip install openpyxl

This resolved the problem for me.

I'm getting the below error Traceback (most recent call last): File "C:\Python34\lib\runpy.py", line 171, in run_module_as_main "main", mod_spec) File "C:\Python34\lib\runpy.py", line 86, in _run_code exec(code, run_globals) File "C:\Python34\Scripts\pip.exe__main_.py", line 5, in <module> ImportError: cannot import name 'main'

Jose Antonio · Accepted Answer · 2024-12-07 22:51:33Z

If you are using Visual Studio Code, just try to reopen the vscode code editor since it does not save the changes properly.

Giorgio Cinciripini · Accepted Answer · 2024-12-04 11:17:26Z

-1

import openpyx1

ModuleNotFoundError: No module named 'openpyx1'

Why?! I got the following enter image description here

that confirms (?) that the module is installed ...

answered Dec 4, 2024 at 11:17

Giorgio Cinciripini

1

3 Comments

Vincent Flotron Dec 4, 2024 at 16:07

It looks like you are posting a question. But by using an answer. It is not the correct way to proceed because instead of helping people, your answer is disturbing.

Martin Dec 5, 2024 at 11:20

If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review

Anerdw Dec 9, 2024 at 15:28

This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. To get notified when this question gets new answers, you can follow this question. Once you have enough reputation, you can also add a bounty to draw more attention to this question. - From Review

Collectives™ on Stack Overflow

Python cannot import openpyxl

10 Answers 10

3 Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

1 Comment

Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

3 Comments

Comments

Comments

Comments

Comments

1 Comment

Comments

1 Comment

Comments

3 Comments

Linked

Related