Automate Excel with Python using OpenPyXL
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