How to Install openpyxl on Windows
openpyxl is a Python library to read/write Excel 2007 xlsx/xlsm files. To download and install on Windows:
Then to install, extract the tar ball you downloaded, open up CMD, navigate to the folder that you extracted and run the following:
C:\Users\Gungor>cd Downloads\openpyxl-2.1.2.tar\dist\openpyxl-2.1.2\openpyxl-2.1.2 C:\Users\Gungor\Downloads\openpyxl-2.1.2.tar\dist\openpyxl-2.1.2\openpyxl-2.1.2>python setup.py install
It’s going to install everything and will report any error. If there is nothing that seems like an error. You’re good to go. Verify the installation by opening Python (command line) and running the following line in Python CMD:
>>> from openpyxl import Workbook >>>
openpyxl documentation is a great place to start with it.
For an introduction to other tools for working with Excel and Python see https://www.pyxll.com/blog/tools-for-working-with-excel-and-python/.