Automating Excel with Python, the video course, will help you learn how to read and write Microsoft Excel spreadsheets with the Python programming language.
You can use several different Python packages to work with Excel, but this book will focus on OpenPyXL.
The OpenPyXL package allows you to work with Excel files on Windows, Mac and Linux, even if Excel isn't installed.
In this course and the companion book, you will learn about the following:
- Opening and Saving Workbooks
- Reading Cells and Sheets
- Creating a Spreadsheet (adding/deleting rows and sheets, merging cells, folding, freeze panes)
- Cell Styling (font, alignment, side, border, images)
- Conditional Formatting
- and more!
Python is a great language that you can use to enhance your daily work, whether you are an experienced developer or a beginner!
What You Get
- 10 Videos
- Jupyter Notebooks
- The Automating Excel with Python eBook
You'll get ten videos and an eBook that teach you how to automate Excel with Python