1
00:00:00,005 --> 00:00:01,003
- [Instructor] In this chapter,

2
00:00:01,003 --> 00:00:03,008
we're going to learn about openpyxl

3
00:00:03,008 --> 00:00:08,003
and how to use it to work with Excel files and data.

4
00:00:08,003 --> 00:00:11,003
Openpyxl is a Python library that enables you

5
00:00:11,003 --> 00:00:14,005
to interact with Excel files programmatically,

6
00:00:14,005 --> 00:00:18,006
and it goes beyond simply opening and viewing spreadsheets.

7
00:00:18,006 --> 00:00:21,004
It provides features to read and write data,

8
00:00:21,004 --> 00:00:24,005
set formatting, create and remove worksheets,

9
00:00:24,005 --> 00:00:26,004
and manipulate the entire structure

10
00:00:26,004 --> 00:00:30,001
of Excel files with Python code.

11
00:00:30,001 --> 00:00:33,002
With openpyxl, you can automate a lot of tasks

12
00:00:33,002 --> 00:00:35,009
that would otherwise require manual work.

13
00:00:35,009 --> 00:00:38,007
You can create spreadsheets from multiple data sources,

14
00:00:38,007 --> 00:00:42,002
including databases, web services, local files,

15
00:00:42,002 --> 00:00:45,000
just about any data source really.

16
00:00:45,000 --> 00:00:48,002
You can combine multiple data sources into a single workbook

17
00:00:48,002 --> 00:00:50,001
and create formatted reports

18
00:00:50,001 --> 00:00:53,004
that derive new data from the data in the workbook.

19
00:00:53,004 --> 00:00:57,008
You can even create charts and templates using Python code.

20
00:00:57,008 --> 00:00:59,005
With openpyxl, you can easily build

21
00:00:59,005 --> 00:01:02,002
and deploy powerful data processing workflows

22
00:01:02,002 --> 00:01:05,000
anywhere that you can run Python.

23
00:01:05,000 --> 00:01:08,004
Openpyxl is also used by the Pandas library

24
00:01:08,004 --> 00:01:10,005
to perform operations on Excel files,

25
00:01:10,005 --> 00:01:14,000
which we will learn about more later in the course.

26
00:01:14,000 --> 00:01:16,003
It's an incredibly popular library.

27
00:01:16,003 --> 00:01:19,004
Let's take a look at the download stats here on PyPI Stats,

28
00:01:19,004 --> 00:01:21,002
and you can see that it gets millions

29
00:01:21,002 --> 00:01:23,001
of downloads every day.

30
00:01:23,001 --> 00:01:24,003
You can find the documentation

31
00:01:24,003 --> 00:01:26,007
for openpyxl here at this link,

32
00:01:26,007 --> 00:01:29,001
and I would suggest keeping this open in a browser tab

33
00:01:29,001 --> 00:01:31,006
to refer to as we go through the chapter.

34
00:01:31,006 --> 00:01:33,001
I encourage you to refer to these docs

35
00:01:33,001 --> 00:01:34,008
during the course in case you want

36
00:01:34,008 --> 00:01:36,006
to try out some experiments of your own

37
00:01:36,006 --> 00:01:39,000
as we progress through the chapter.