Autoplay
Autocomplete
Previous Lesson
Complete and Continue
xlwings: Python for Excel
Course Introduction
Start here: Instructions
A note about Language & Regional Settings
xlwings for Absolute Beginners (21:06)
Install the Anaconda Python distribution (4:13)
Python default installation (7:42)
Upgrade xlwings (6:28)
Jupyter Notebook (2:37)
Tutorial 1 (BEGINNER, Win & Mac): The Basics (47:45)
Description and Material
How does it work?! (1:13)
xw.view(), Connect to a book, Range object (9:22)
2d Ranges (2:17)
1d Ranges (2:58)
autofit and background color (0:51)
Range indexing/slicing (1:00)
Full qualification with app object / Multiple Excel instances (3:39)
Active Objects (1:53)
Sheets with Range shortcut (sheet[...]) (3:07)
Excel charts & Matplotlib (7:35)
Excel's Table Objects (3:38)
Efficiency (2:57)
Workaround for missing features (3:31)
Calling VBA Subs/Functions (2:34)
Tutorial 2 (BEGINNER, Win & Mac): Converters and Options (12:17)
Description and Material
Default and dict converters (5:29)
NumPy and Pandas converters (6:48)
Tutorial 3 (BEGINNER, Win & Mac): RunPython (25:42)
Description and Material
How does it work?! (1:55)
Excel add-in: installation (5:46)
xlwings quickstart (CLI) & RunPython (VBA) (6:20)
Excel add-in: settings / config files (11:41)
Tutorial 4 (BEGINNER, Win only): User Defined Functions (UDFs) (32:50)
Description & Material
How does it work?! (2:21)
One-off preparations (1:22)
Our first UDF: Hello World (5:23)
Array Formulas (4:47)
Numpy and Pandas converters & options: @xw.arg and @xw.ret decorators (6:11)
Dynamic Arrays (4:40)
Excel add-in: UDF specific settings (2:42)
In-Excel SQL extension (2:40)
A practical example (2:42)
Asynchronous Functions (2:14)
Tutorial 5 (ADVANCED): Advanced xlwings topics (56:35)
Description & Material
Debugging RunPython (7:28)
Debugging UDFs (Win only) (7:54)
Real time feeds: Write from Python to Excel (3:11)
Real time feeds: Read Excel from Python (2:23)
Custom xlwings Extensions (11:35)
Custom Converters (14:04)
Call Python functions from VBA in other office apps (e.g. MS Access) (Win only) (8:24)
REST API (9:56)
TUTORIAL 6 (ADVANCED, Win & Mac): Unit Testing (21:54)
Description & Material
Introduction to unit tests and Python's unittest module (10:39)
Use Python and xlwings to unit test your mission critical Excel tools (11:14)
TUTORIAL 7 (ADVANCED, Win & Mac): App development & Deployment (24:33)
Description & Material
Prototyping web apps with xlwings (8:23)
Python package (5:46)
xlwings as standalone VBA module (2:51)
Frozen executable (Win only) (7:33)
xlwings Server
Custom Functions (33:30)
Custom Scripts (18:06)
Task Pane Development (5:16)
Frozen executable (Win only)
Complete and Continue
Discussion
19
comments
Load more
19 comments