It is common for data frames to be stored in excel files or as .csv files. Therefore, it is required for most programming languages to be equipped with utilities that allow the user to process such files. Openpyxl is a Python library for reading and writing Excel files with extensions like xlsx, xlsm, xltx, xltm. It provides different modules to process Excel files without involving any other third-party software. This article will teach you how to install the openpyxl library in Python on Windows Operating System.
Installing openpyxl in Python
We can install openpyxl on Windows via 2 different methods.
- Installing using PIP Manager
- Installing using the official package
Method 1: Installing using PIP Manager
Step 1: Open the start menu by pressing the [Win] key or clicking the bottom left section of the desktop
Start > Windows Ease of Access
Step 2: Type cmd in the menu. Results similar to the following would have appeared
cmd
Step 3: Select the cmd app from the suggestions and click on Run as administrator.
Step 4: A new window would have appeared similar to this
Step 5: Type the following command and press Enter.
py -m pip install openpyxl
Now the openpyxl library has been successfully installed in your Python distribution.
Method 2: Installing using the official package
Another way of installing openpyxl on your python distribution is by downloading the package from their site and installing it manually.
Step 1: Open the download page for openpyxl from the following link.
https://pypi.org/project/openpyxl/#files
Step 2: Click on the source distribution link.
Step 3: The download would have started.
Step 4: Now go to the path where the file has been downloaded, right-click the file and select the option extract here.
Step 5: When the process of extraction of files has been completed, a directory similar to this would have appeared.
The directory would contain the following files
Step 6: Now open cmd.exe and change the current working directory to the path of this directory:
Step 7: Now enter the following command:
py setup.py install
Upon completion of the command, openpyxl would be installed in your python distribution.
