Writing Excel Functions in Python ¶

In this video we’ll introduce you to writing Excel worksheet functions, or UDFs, in Python using PyXLL.

Worksheet functions are one of the most common ways to call Python code from Excel. Your Python functions are exposed to Excel to be called from an Excel worksheet in just the same way as you would call one of the built-in Excel functions.

This video covers the following topics:

1. What is a worksheet function or UDF?
2. Calling Python functions from Excel
3. Passing arguments from Excel to Python
4. Using pandas DataFrames in Excel
5. Passing Python objects between functions