A beginner-friendly repository documenting my journey of learning OpenPyXL, a Python library for reading, writing, and modifying Microsoft Excel (.xlsx) files.
This project contains hands-on practice examples covering the fundamentals of Excel automation with Python.
- Load existing Excel workbooks
- Create new workbooks and worksheets
- Read and update cell values
- Iterate through rows and columns
- Access multiple worksheets
- Save changes to Excel files
- Practice real-world Excel automation tasks
- Python 3
- OpenPyXL
learn-openpyxl/
│
├── files/
├── *.py
├── README.md
├── requirements.txt
└── .gitignore
Clone the repository:
git clone https://github.com/your-username/learn-openpyxl.git
cd learn-openpyxlInstall the required package:
pip install -r requirements.txtExecute any Python script using:
python filename.pyThrough this project, I learned how to:
- Work with Excel spreadsheets programmatically
- Read and write worksheet data
- Create and manage workbooks
- Modify existing Excel files
- Automate repetitive spreadsheet operations
- OpenPyXL Documentation: https://openpyxl.readthedocs.io/
- Python Documentation: https://docs.python.org/3/
This repository is part of my Python learning journey and serves as a reference for understanding the fundamentals of Excel automation using OpenPyXL.