From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data

Overview of openpyxl

From the course: Advanced Hands-On Python: Working with Excel and Spreadsheet Data

Start my 1-month free trial Buy for my team

Overview of openpyxl

“

- [Instructor] In this chapter, we're going to learn about openpyxl and how to use it to work with Excel files and data. Openpyxl is a Python library that enables you to interact with Excel files programmatically, and it goes beyond simply opening and viewing spreadsheets. It provides features to read and write data, set formatting, create and remove worksheets, and manipulate the entire structure of Excel files with Python code. With openpyxl, you can automate a lot of tasks that would otherwise require manual work. You can create spreadsheets from multiple data sources, including databases, web services, local files, just about any data source really. You can combine multiple data sources into a single workbook and create formatted reports that derive new data from the data in the workbook. You can even create charts and templates using Python code. With openpyxl, you can easily build and deploy powerful data processing workflows anywhere that you can run Python. Openpyxl is also used by the Pandas library to perform operations on Excel files, which we will learn about more later in the course. It's an incredibly popular library. Let's take a look at the download stats here on PyPI Stats, and you can see that it gets millions of downloads every day. You can find the documentation for openpyxl here at this link, and I would suggest keeping this open in a browser tab to refer to as we go through the chapter. I encourage you to refer to these docs during the course in case you want to try out some experiments of your own as we progress through the chapter.

Contents