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?

Answer 1

You need to ensure that C:\Python35\Sripts 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.

Answer 2

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

Answer 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.

Answer 4

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

Answer 5

(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

Answer 6

For me it worked as Kumar Jaggal but: steps 1, 2, 3, the same 4. py -m setup.py install