openpyxl?openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files.
Using pip or pip3, as below:
pip install openpyxl
This command will download and install the latest stable version of openpyxl and its dependencies. You’ll need Python 3.7 or higher.
pip install openpyxl
Collecting openpyxl
Downloading openpyxl-3.1.5-py2.py3-none-any.whl.metadata (2.5 kB)
Collecting et-xmlfile (from openpyxl)
Downloading et_xmlfile-2.0.0-py3-none-any.whl.metadata (2.7 kB)
Downloading openpyxl-3.1.5-py2.py3-none-any.whl (250 kB)
Downloading et_xmlfile-2.0.0-py3-none-any.whl (18 kB)
Installing collected packages: et-xmlfile, openpyxl
Successfully installed et-xmlfile-2.0.0 openpyxl-3.1.5
Keep your pip in the latest version via pip intall --upgrade pip command.
After successful installation, you can verify it by importing the library in a Python interpreter:
>>> import openpyxl
If no errors occurs, openpyxl is correctly installed.
If your installation is not successfully, you may see following error for further troubleshooting:
>>> import openpyxl
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
import platform
ModuleNotFoundError: No module named 'openpyxl'
openpyxl represents an Excel file as a workbook, which contains one or more worksheets. A worksheet is a grid of cells organized into rows and columns. Each cell can contain different data types: numbers, text, formulas, dates, booleans, etc.
Here are the key terminologies:
| Term | Description |
|---|---|
| Workbook | The entire Excel file. It’s represented by the workbook class. |
| Worksheet | A single sheet within the workbook. Represented by the worksheet class. |
| Cell | An individual entry in the worksheet, identified by its column and row coordinates (e.g. “A1”, “B2”). Accessed using worksheet["A1"] or worksheet.cell(row=1, column=1). |
| Row | A horizontal sequence of cells. |
| Column | A vertical sequence of cells. |
| Cell Value | The content of a cell (string, number, formula, etc.) |
| Cell Style | Formatting applied to a cell (font, alignment, number format, etc.) |
from openpyxl import load_workbook, Workbook
# Reding from an existing file
workbook = load_workbook("example.xlsx")
worksheet = workbook.active
# Accessing cell values
cell_value = worksheet['A1'].value
print(f"Value of A1: {cell_value}")
# Iterating through rows
for row in worksheet.iter_rows(
min_row=1,
max_row=5,
min_col=1,
max_col=2
):
for cell in row:
print(f"Cell value [{row}][{cell}] is: {cell.value}")
# Writing to a new file
new_workbook = Workbook()
new_worksheet = new_workbook.active
new_worksheet['A1'] = "Hello, OpenPyXl"
new_worksheet['B2'] = 123
# Save the new workbook
new_workbook.save("new_example1.xlsx")
The dataset is as below sample:
dataset = [
["Month", "Days"],
["January", 31],
["February", 28],
["March", 31],
["April", 30]
]
Solution:
# Name: first_exercise
# Purpose: practive writing into spreadsheet via iterating
# Author: Xiaoqi Zhao
# Date: 2025/12/29
from openpyxl import Workbook
# Provide the dataset for writing into the spreadsheet
dataset = [
["Month", "Days"],
["January", 31],
["February", 28],
["March", 31],
["April", 30]
]
# Writing to a new file
new_workbook = Workbook()
new_worksheet = new_workbook.active
# Iterating through rows
for row in range(1,len(dataset)+1):
for col in range(1,len(dataset[0])+1):
new_worksheet.cell(row,col).value = dataset[row-1][col-1]
print(f"Cell value [{row}][{col}] is: {new_worksheet.cell(row,col).value}")
# Save the new workbook
new_workbook.save("first_exercise.xlsx")
Last Updated at: 12/29/2025, 10:31:31 AM