#100DaysOfCode in Python Transcripts
Chapter: Days 70-72: Excel automation with openpyxl
Lecture: Setup: install openpyxl and your env
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Okay, so the first thing we need to do, as usual, is set up our environment. So we're going to create ourselves a virtual environment, called venv,
0:15
and once that's installed, we are going to launch it. Okay, and then we're going to pip install openpyxl
0:29
That's all we're going to need for this lesson. The other thing you can do, if you wish, is create a Python file in this directory
0:37
called excel_automation. Furthermore, if you want to follow along with the commands, as I type them, you'll want to download the financial sample.
0:50
Okay, this is a document that you'll see in the repo. Pull that Excel file across and you should be able to follow along with that.