Connect Python To Excel - Python and Excel With OpenPyXL #4
In this video we'll create our first program to connect Python with Excel.
First we'll need to import openpyxl into our Python program. Then we'll create a Workbook instance, and set an active sheet to work on.
Think of excel itself as the workbook, and the actual spreadsheet itself as the worksheet.
After that we'll load the actual Excel file that we want to play with.