- [Instructor] There's another very popular Python package
for creating Excel files, and it's named XLSXWriter.
You can see here at this link, these are the download stats
for the package from PyPi,
and you can see it's pretty popular.
It gets, you know, tens of millions
of downloads every month, so maybe not as popular
as OpenPYXL, but still pretty popular.
You can find the documentation
for this project here at this link,
and again, I would suggest you keep this
open in a browser tab.
Now, there's a key difference between this package
and OpenPYXL, and it's right there in the name.
This is XLSXWriter.
Now, unlike OpenPYXL, this package is only used
to write Excel spreadsheets.
You can't read or manipulate their content the same way you
can with Open PI Excel.
Now, depending on your use case,
that might not be a problem.
If you only need to create Excel files
from other data sources and you don't need
to worry about reading data from Excel files,
then XLSXWriter might be a better way to go.
In my personal opinion, the API
and the docs for XLSXWriter are a bit better organized
and easier to use than OpenPYXL is.
So it might be a better fit for some scenarios.
It's very full featured
and you can achieve pretty much all the same results you can
with OpenPYXL, when creating workbooks is the focus.
In this chapter, we're going
to learn about using XLSXWriter
to create workbooks style, their contents,
apply conditional formatting and filters,
and create Excel tables.
And as I said in the previous chapter,
I would suggest keeping the documentation open
in your browser so that you can refer back
to it throughout the chapter when you want to try out some
of your own experiments
or dive deeper into a topic in each
of the sections as we go through them.