Hint: You can adjust the default video playback speed in your account settings.
Hint: You can set your subtitle preferences in your account settings.
Sorry! Looks like there’s an issue with video playback 🙁 This might be due to a temporary outage or because of a configuration issue with your browser. Please refer to our video player troubleshooting guide for assistance.

Excel Spreadsheets in Python With openpyxl (Overview)

Joe Tatusko
Editing Excel Spreadsheets in Python With openpyxl Joe Tatusko 01:08
Recommended Tutorial Course Slides (.pdf) Sample Code (.zip) Ask a Question

Excel spreadsheets are one of those things you might have to deal with at some point. Either it’s because your boss loves them or because marketing needs them, you might have to learn how to work with spreadsheets in Python, and that’s when knowing openpyxl comes in handy!

In this course, you’ll learn how to use openpyxl to:

  • Read Excel spreadsheets and iterate through the data
  • Manipulate speadsheet data using Python data structures
  • Create simple or more complex spreadsheets
  • Format workbooks using styles, filters, and conditional formatting
  • Enhance spreadsheets by adding images and charts
Download

Sample Code (.zip)

 92.3 KB
Download

Course Slides (.pdf)

 254.7 KB

00:00 Hello, and welcome to the Real Python guide to Excel spreadsheets and openpyxl. In these videos, you’re going to learn how to use openpyxl to manipulate Excel workbooks using Python, which is a great way to start automating business tasks.

00:14 The first thing you’re going to see is a bit of terminology and course setup. Next, you’re going to learn how to read Excel spreadsheets using openpyxl.

00:23 And finally, you’ll see how to write Excel spreadsheets.

00:27 When reading Excel spreadsheets, you’re going to see how to: load a workbook, iterate through the data, manipulate the data using Python data structures.

00:37 For writing Excel spreadsheets, there’s quite a bit you can do. First, you’ll see how to manage the rows and columns. Then, you’ll see how to manage each individual sheet.

00:47 The next thing you’ll learn is how to add filters and formulas, and then you’ll see how you can style cells and add conditional formatting. Finally, you’ll see how to add images and charts. There’s quite a bit to cover, so in the next video, you’re going to set up an environment, get some sample data, and create your first worksheet. See you there.

Become a Member to join the conversation.