# 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

## Ready to dive in? Start learning today.

[Get Started](/content/app/get-started/index.html)