Automate Excel with Python using OpenPyXL
Automate Excel with Python using OpenPyXL
Duration: 52m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 436 MB
Genre: eLearning | Language: English
Duration: 52m | .MP4 1280x720, 30 fps(r) | AAC, 48000 Hz, 2ch | 436 MB
Genre: eLearning | Language: English
In this course you'll get the skills to automate Excel with the Power of Python!
Using OpenPyXL module you will learn how to read and write Excel Files, work with sheets and styles.
Since this is intermediate Python you are required to already master the basics of Python before enrolling into this class. My advice is to first check my other classes on Python published here on SkillShare; they will help you build a strong foundation of Python Programming Language.
In this course we'll get the skills to get ahead!
Major topics of this Python and Excel course:
Setup the Environment. Installing OpenPyXL
Excel Basics
Reading Excel Documents
Reading Data in a Cell Range
Writing Excel Files
Creating New Excel Files
Using Excel Formulas
Sheets Operations
Working with Styles
and more!
Excel file used in the course: https://drive.google.com/open?id=1NANQ_sVqWK1d-JvE9B3Zd9ZKxpQxAG8K