In this video, I will show you how to automate Excel with Python using OpenPyXL.
Enjoy the Video
⏰Timestamps⏰
00:00 Intro
01:16 Download OpenPyXL Package
01:46 VSCode
03:03 Python Code
06:30 Create New Workbook
10:20 Create New Work Sheet
11:37 Access Worksheet Data
17:06 Merge and Unmerge Cells
20:30 Add Columns and Rows in Sheet
33:29 Outro
💻 To get more of our best content on IT careers and IT certifications, go to:
Be sure to leave any questions or comments below!
See More Videos and Subscribe:
/ @skillsbuildtraining
Website:
Facebook: / skillsbuildtraining
Twitter: / skillsbuildt