How to install Openpyxl with pip

Question

I have windows 10 (64 bit). I want to utilize the Openpyxl package to start learning how to interact with excel and other spreadsheets.

I installed Python with "windowsx86-64web-basedinstaller" I have a 64 bit OS, was I mistaken when trying to install this version?

Lee Taylor · Accepted Answer · 2022-01-30 19:50:39Z

You need to ensure that C:\Python35\Scripts is in your system path. Follow the top answer instructions here to do that:

You run the command in windows command prompt, not in the python interpreter that you have open.

Press:

Win + R

Type CMD in the run window which has opened

Type pip install openpyxl in windows command prompt.

malioboro · Accepted Answer · 2017-01-20 06:32:27Z

3

I had to do: c:\Users\xxxx>c:/python27/scripts/pip install openpyxl I had to save the openpyxl files in the scripts folder.

3,3514 gold badges38 silver badges57 bronze badges

answered Jan 20, 2017 at 6:03

411 bronze badge

Comments

Kumar Jaggal · Accepted Answer · 2018-01-10 14:46:31Z

https://pypi.python.org/pypi/openpyxl download zip file and unzip it on local system.
go to openpyxl folder where setup.py is present.
open command prompt under the same path.
Run a command: python setup.py install
It will install openpyxl.

Haha TTpro · Accepted Answer · 2018-07-07 17:03:32Z

(optional) Install git for windows (https://git-scm.com/) to get git bash. Git bash is much more similar to Linux terminal than Windows cmd.

Install Anaconda 3

https://www.anaconda.com/download/

It should set itself into Windows PATH. Restart your PC. Then pip should work in your cmd

Then in cmd (or git bash), run command

pip install openpyxl

Don Gonzalo Cortez Mayer · Accepted Answer · 2018-08-07 19:27:10Z

Go to https://pypi.org/project/openpyxl/#files
Download the file and unzip in your pc in the main folder, there's a file call setup.py
Install with this command: python setup.py install

Ashok · Accepted Answer · 2021-01-02 06:51:24Z

go to command prompt, and run as Administrator
in c:/> prompt -> pip install openpyxl
once you run in CMD you will get message like, Successfully installed et-xmlfile-1.0.1 jdcal-1.4.1 openpyxl-3.0.5
go to python interactive shell and run openpyxl module
openpyxl will work