1
00:00:00,005 --> 00:00:02,008
- [Instructor] There's another very popular Python package

2
00:00:02,008 --> 00:00:06,009
for creating Excel files, and it's named XLSXWriter.

3
00:00:06,009 --> 00:00:10,003
You can see here at this link, these are the download stats

4
00:00:10,003 --> 00:00:12,008
for the package from PyPi,

5
00:00:12,008 --> 00:00:14,006
and you can see it's pretty popular.

6
00:00:14,006 --> 00:00:16,005
It gets, you know, tens of millions

7
00:00:16,005 --> 00:00:19,003
of downloads every month, so maybe not as popular

8
00:00:19,003 --> 00:00:22,004
as OpenPYXL, but still pretty popular.

9
00:00:22,004 --> 00:00:23,007
You can find the documentation

10
00:00:23,007 --> 00:00:26,008
for this project here at this link,

11
00:00:26,008 --> 00:00:28,006
and again, I would suggest you keep this

12
00:00:28,006 --> 00:00:30,003
open in a browser tab.

13
00:00:30,003 --> 00:00:33,001
Now, there's a key difference between this package

14
00:00:33,001 --> 00:00:36,005
and OpenPYXL, and it's right there in the name.

15
00:00:36,005 --> 00:00:39,004
This is XLSXWriter.

16
00:00:39,004 --> 00:00:43,007
Now, unlike OpenPYXL, this package is only used

17
00:00:43,007 --> 00:00:45,007
to write Excel spreadsheets.

18
00:00:45,007 --> 00:00:49,001
You can't read or manipulate their content the same way you

19
00:00:49,001 --> 00:00:51,004
can with Open PI Excel.

20
00:00:51,004 --> 00:00:53,002
Now, depending on your use case,

21
00:00:53,002 --> 00:00:54,007
that might not be a problem.

22
00:00:54,007 --> 00:00:56,009
If you only need to create Excel files

23
00:00:56,009 --> 00:00:58,007
from other data sources and you don't need

24
00:00:58,007 --> 00:01:01,005
to worry about reading data from Excel files,

25
00:01:01,005 --> 00:01:05,000
then XLSXWriter might be a better way to go.

26
00:01:05,000 --> 00:01:06,009
In my personal opinion, the API

27
00:01:06,009 --> 00:01:10,008
and the docs for XLSXWriter are a bit better organized

28
00:01:10,008 --> 00:01:13,005
and easier to use than OpenPYXL is.

29
00:01:13,005 --> 00:01:16,006
So it might be a better fit for some scenarios.

30
00:01:16,006 --> 00:01:18,002
It's very full featured

31
00:01:18,002 --> 00:01:21,002
and you can achieve pretty much all the same results you can

32
00:01:21,002 --> 00:01:26,002
with OpenPYXL, when creating workbooks is the focus.

33
00:01:26,002 --> 00:01:27,006
In this chapter, we're going

34
00:01:27,006 --> 00:01:29,008
to learn about using XLSXWriter

35
00:01:29,008 --> 00:01:32,008
to create workbooks style, their contents,

36
00:01:32,008 --> 00:01:35,004
apply conditional formatting and filters,

37
00:01:35,004 --> 00:01:38,002
and create Excel tables.

38
00:01:38,002 --> 00:01:40,008
And as I said in the previous chapter,

39
00:01:40,008 --> 00:01:43,001
I would suggest keeping the documentation open

40
00:01:43,001 --> 00:01:45,002
in your browser so that you can refer back

41
00:01:45,002 --> 00:01:48,000
to it throughout the chapter when you want to try out some

42
00:01:48,000 --> 00:01:49,002
of your own experiments

43
00:01:49,002 --> 00:01:51,001
or dive deeper into a topic in each

44
00:01:51,001 --> 00:01:53,000
of the sections as we go through them.