Excel Spreadsheets in Python With openpyxl (Summary)
Congratulations, you now know how to work with Excel spreadsheets in Python!
In the course you have learned how to:
- Extract valuable information from spreadsheets in a Pythonic manner
- Create your own spreadsheets, no matter the complexity level
- Add cool features such as conditional formatting or charts to your spreadsheets
Here are resources for more information about
Congratulations, you made it to the end of the course! What’s your #1 takeaway or favorite thing you learned? How are you going to put your newfound skills to use? Leave a comment in the discussion section and let us know.
Congratulations. You’ve just learned a ton about how to use
openpyxl to use Python to work with Excel workbooks. This course covered a lot of different topics, so let’s take a few minutes to cover what you’ve learned.
The first thing that you saw was some terminology and did some course setup to get your sample data and your installations. Next, you saw a bunch of different ways to read Excel spreadsheets using
Then, the focus was on how to write Excel spreadsheets with
openpyxl. For reading Excel spreadsheets, you saw how to load a workbook, iterate through the data, and then manipulate the data using Python data structures. For writing Excel spreadsheets, you saw that there were quite a few things that you could do when you were creating these. First, you saw how to manage the rows and columns.
Then, you saw how to manage the sheets. You then learned how to use
openpyxl to add filters and formulas to your worksheets, and then how to style cells while also adding conditional formatting. Finally, you saw how to add images and charts to your worksheets.
Become a Member to join the conversation.