Python Mastery – From Basics to Brilliance / Python Libraries for Real-World Use

OpenPyXL – Excel Automation

📊 OpenPyXL

OpenPyXL is a Python library used to create, read, modify, and format Excel (.xlsx) files.

It is especially useful for automating Excel tasks.

📦 Install

pip install openpyxl

Import it:

import openpyxl

📖 Read an Excel File

import openpyxl

workbook = openpyxl.load_workbook("students.xlsx")
sheet = workbook.active

print(sheet["A1"].value)

✏️ Write Data

sheet["A1"] = "Name"
sheet["B1"] = "Age"

sheet["A2"] = "Tisha"
sheet["B2"] = 23
workbook.save("students.xlsx")

📄 Create a New Excel File

import openpyxl

workbook = openpyxl.Workbook()
sheet = workbook.active

sheet["A1"] = "Name"
sheet["A2"] = "Tisha"

workbook.save("students.xlsx")

🔧 Common OpenPyXL Functions

openpyxl.Workbook()          # Create a new workbook
openpyxl.load_workbook()     # Open an existing workbook

sheet["A1"].value            # Read a cell
sheet["A1"] = "Hello"        # Write to a cell

workbook.save("file.xlsx")   # Save workbook