#100DaysOfCode in Python Transcripts
Chapter: Days 70-72: Excel automation with openpyxl
Lecture: Your 3 day overview
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.