Editing Excel Spreadsheets in Python With openpyxl

Course Description

Skill level: intermediate

In this course, you'll learn how to handle spreadsheets in Python using the openpyxl package. You'll learn how to manipulate Excel spreadsheets, extract information from spreadsheets, create simple or more complex spreadsheets, including adding styles, charts, and so on.

Editing Excel Spreadsheets in Python With openpyxl

1. Excel Spreadsheets in Python With openpyxl (Overview)

2. Starting With "Hello World"

3. Reading Excel Spreadsheets

4. Iterating Through the Data

5. Manipulating the Data

6. Appending Data to Spreadsheets

7. Managing Rows and Columns

8. Managing Sheets

9. Adding Filters and Formulas

10. Styling Cells

11. Adding Conditional Formatting

12. Adding Images

13. Adding Charts

14. Making a Mapping File

15. Working With Pandas

16. Excel Spreadsheets in Python With openpyxl (Summary)

View Course Details »

This person’s account is verified and was created on Dec. 8, 2020. Real Python certifies their completion of the Editing Excel Spreadsheets in Python With openpyxl course on Jan. 16, 2021.

Real Python is an online learning platform and expert community for Python software developers. It offers interactive online classes and in-depth tutorials created by a team of subject matter experts.