#100DaysOfCode in Python Transcripts
Chapter: Days 70-72: Excel automation with openpyxl
Lecture: Your 3 day overview
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Okay, for the next three 3 with ppenpyxl,
0:03
here's what you're going to do.
0:05
For the first day, obviously, there's going to be a bit
0:07
of setup for it and I will be going through
0:10
explaining the workbooks and worksheets.
0:13
Okay, that's in that video there.
0:15
And after we do that we're then going to deal with
0:18
pulling some cell values,
0:19
so pulling data out of the spreadsheet.
0:22
It's going to be pretty simple,
0:24
but it's going to be pretty useful, okay?
0:27
So use the financial sample xlsx file,
0:31
it's located in this repo, okay?
0:34
For Day 2, you're going to actually expand on everything
0:38
you learned in day one with max row,
0:41
and then on inserting data into the spreadsheet, okay?
0:46
That's a very useful one, as you can imagine.
0:48
So that's going to be a lot of fun.
0:50
Once you're done watching the videos, obviously,
0:52
play around again with that spreadsheet,
0:55
and play with inserting data.
0:57
So maybe do it one cell at a time.
1:00
And then try populating an entire column, okay?
1:04
For Day 3, this again as usual,
1:06
is where you're going to do it yourself.
1:08
Okay, come up with something cool.
1:10
Ideas, perhaps try editing an employee shift roster.
1:16
Okay, so imagine a roster in a spreadsheet
1:19
of people's names and times and dates and whatever,
1:23
and maybe monitor it for changes, okay?
1:26
So there's a script that
1:27
does something when something changes,
1:28
or perhaps a script that allows an employee to update it.
1:33
So your spreadsheet is almost like your data base.
1:36
Okay, you could also try doing that with a financial budget,
1:40
something similar, so when you get a list, or a dictionary,
1:44
of spending data, it updates the spreadsheet, okay?
1:48
You could even populate the spreadsheet with data,
1:50
pull down from an API of some sort.
1:53
Okay, so have a go, enjoy it, and excuse the pun.