Excel Automation with OpenPyXL
Learn how to read, write and manipulate Excel files with Python with the OpenPyXL module.
TECHNOLOGIES
- Excel
- File Automation
WATCH TIME
45 minutes
Lessons
Setting Fonts and Formulas
Learn how to set an Excel spreadsheet's fonts and create cell formulas with Python and OpenPyXL.
6 min
Accessing Columns and Rows
Learn how to access columns and rows of Excel spreadsheets with Python and OpenPyXL.
4 min
Writing and Saving to Spreadsheets
Learn how to automate writing and saving of Excel spreadsheets with Python and OpenPyXL.
7 min
Automate Creating Excel Charts
Learn how to automate the creation of Excel Charts from spreadsheet data with Python and OpenPyXL.
8 min
Adjusting Rows and Columns
Learn how to automate the adjustment of the row and column sizes in Excel with Python and OpenPyXL.
4 min
Reading Sheets and Cells
Learn how to read Excel spreadsheets and individual cells with OpenPyXL and Python.
7 min
Introduction to OpenPyXL
Learn all about OpenPyXL - a package used to automate and manipulate Excel spreadsheets.
6 min
Merging Cells and Freezing Panes
Learn how to merge spreadsheet cells and freeze panes on Excel with Python and OpenPyXL.
6 min
Hey! I’m Avi, and I’ll teach you how to build!
I'm Avi, your new Python instructor and founder of The Codex.
Three years ago I was stuck. I wasn’t learning anything in my theory-filled CS classes, my friends took pictures of me sleeping in lecture, and I was questioning why I was even learning CS to begin with. I had ideas but I was clueless on execution.
After watching hours of webcasted YouTube videos, enrolling in course after course, and struggling to stay motivated, I finally obtained the skills to bring my ideas to life. I realized how lonely and gruesome this process was.
If you’re a student just like me, you know exactly what it’s like to be stuck in course hell. The best programmers of today learned by doing, not by reading syntax in a textbook.
Join The Codex. Become a creator.
Savvy Students ❤️ The Codex
The Codex has helped hundreds of students find jobs and build their dream projects.
"For the first time in my life I’ve found a platform that can keep me engaged for more than 5 minutes. Project on The Codex are entertaining, informative, and more valuable than the countless hours of lectures I watched at 2x speed in school."
— Maddie Wilson
University of Toronto, 2023