Simple steps to install openpyxl on Windows

Openpyxl is a python library to perform read/write excel xlsx/xlsm/xltx/xltm files.

Below are the simple steps to install openpyxl on Windows

  1. Click below link to download openpyxl package

Download openpyxl package

  1. Goto Navigation – > Download Files
  2. Download the openpyxl package by clicking on openpyxl.x.x.x.tar.gz file link (x.x.x is version number)
  3. Extract the downloaded TAR file (recommended to extract it to python folder on C drive) Note: When you extract the file, extracted folder contains openpyxl.x.x.x.tar. You need to extract it again to get the installation files.
  4. Open command prompt or Powershell
  5. Navigate to the folder that you extracted in step 4 (folder contains below files)
  6.   extracted-openpyxl-files

 

 

 

 

 

 

6.Then type below command to install openpyxl

          pip install openpyxl

Done. openpyxl will be installed on Windows.

7. If above command doesn’t work, try below command

          python setup.py install

command-to-install-openpyxl-on-windows

 

 

Also Check

Insert image pixels to excel sheet in Python [pixel value + background color]

Simple steps to install/uninstall pygame on windows [using pip]

Top Rated Python Books on Amazon 2020

About the Author

SRINI S

A passionate blogger. Love to share solutions and best practices on wordpress hosting, issues and fixes, excel VBA macros and other apps

Leave a Reply

Your email address will not be published. Required fields are marked *