xlwings: Python for Excel
The Official Course
xlwings is the most popular open-source library to program Excel with Python instead of VBA. This on-demand course is a series of video tutorials that guide the student step by step through the possibilities, lesser known features and pitfalls with xlwings. The current runtime is approx. 4:20 hours.
The tutorials are split into short videos (usually between 5 and 10 minutes) so that it is easy to quickly find the topics of interest. The course material comes in the form of Jupyter notebooks and is available for download.
There are free preview videos available from almost all sections, so make sure to check out the class curriculum!
Your Instructor
Felix created xlwings in 2014 and has been its maintainer ever since. He also teaches class room courses to companies and solves xlwings related problems for companies from small to big. He is also the top answerer on Stack Overflow with regards to xlwings questions.
Course Curriculum
-
StartDescription and Material
-
StartHow does it work?! (1:13)
-
Startxw.view(), Connect to a book, Range object (9:22)
-
Start2d Ranges (2:17)
-
Start1d Ranges (2:58)
-
Startautofit and background color (0:51)
-
StartRange indexing/slicing (1:00)
-
StartFull qualification with app object / Multiple Excel instances (3:39)
-
StartActive Objects (1:53)
-
StartSheets with Range shortcut (sheet[...]) (3:07)
-
StartExcel charts & Matplotlib (7:35)
-
StartExcel's Table Objects (3:38)
-
PreviewEfficiency (2:57)
-
StartWorkaround for missing features (3:31)
-
StartCalling VBA Subs/Functions (2:34)