Editing Excel Spreadsheets in Python With openpyxl

Editing Excel Spreadsheets in Python With openpyxl
Editing Excel Spreadsheets in Python With openpyxl
English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 1h 13m | 470 MB

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
Table of Contents

1 Intro
2 Styling Cells
3 Conditional Formatting
4 Adding Images
5 Adding Charts
6 Making a Mapping File
7 Working with Pandas
8 Wrap Up
9 Hello World
10 Reading Excel Spreadsheets with openpyxl
11 Iterating Through the Data (audio redo)
12 Manipulate the Data
13 Appending Data to Spreadsheets
14 Managing Rows and Columns
15 Managing Sheets
16 Adding Filters and Formulas