IIRF Online > Office Productivity > Other Office Productivity > Python Scripting > Control Excel with Python & OpenPyXL
Control Excel with Python & OpenPyXL by Udemy
Become an Excel Power User with Python & OpenPyXL
Course Highlights
- Controlling Excel with Python
- Automate Excel with Python
- How to use OpenPyXL
Skills you will learn!
Curriculum
6 Topics
Welcome to the course!
Getting started
Installing OpenPyXL
Reading the documentation
Be careful with your workbooks always backup!
Introduction Quiz
8 Topics
Workbooks and Sheets introduction
Creating Workbooks
Opening Workbooks
Writing and saving to Sheets Creating and Deleting Sheets
Copying Sheets
Getting sheet by index and name
Workbooks and Sheets Summary
Workbooks and Sheets quiz
5 Topics
Reading cells introduction
Reading Cells with absolute and relative referencing
Offset
Reading a Range of Cells
Reading data from Cells quiz
5 Topics
Iterating over Cells introduction
Looping over Cells
iter_rows and iter_cols
max_row and max_col
Iterating over Cells quiz
8 Topics
Manipulating Cells introduction
Deleting and inserting rows and columns
The append method for rows
Moving and copying Ranges of Cells
Inserting formulas
Tables
Halfway through!
Manipulating Cells quiz
9 Topics
Formatting & filtering introduction
Formatting cells fonts colors cell type (date text etc)
Copying cell formatting
Merge and unmerge cells
Autofilter
Freeze panes
Page setup
Fold
Formatting and Filtering quiz
5 Topics
Visuals introduction
Creating charts
Chartsheets
Inserting Images
Visuals quiz
7 Topics
Useful Python code introduction
Tkinter file dialogs
Creating files and folders
Getting file path and name
Opening multiple files
Timing your scripts
Start Excel for viewing your work
1 Topic
Your next steps
Control Excel with Python & OpenPyXL
Related Python Scripting Courses
Thank You!
Your review has been submitted successfully.