- [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.