PyXLL The Python Excel Add-In
  • Product
    • Features
    • Get Started
    • Request Demo
    • Download
  • Pricing
  • Resources
    • Documentation
    • Blog
    • Videos
    • FAQ
    • Learn Python
    • Customer Portal
    • About Us
  • Support
    • Documentation
    • Videos
    • FAQ
    • Contact Us
  • Contact Us
Table of Contents
  • PyXLL Documentation
  • Introduction to PyXLL
  • User Guide
  • Video Guides and Tutorials
    • Installing the PyXLL Add-in
    • Writing Excel Functions in Python
    • Jupyter Notebooks in Excel
    • Debugging Python in Excel
    • Working with Tables
    • Monte Carlo Simulations
    • Cell Formatting
    • RTD Array Functions
    • DOOM in Excel
    • NLP VLOOKUP using Scikit Learn
    • Deploying your PyXLL Add-in
  • API Reference
  • What’s new in PyXLL 5
  • Changelog
Close

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.

Calling Python functions from Excel as worksheet 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

« Installing the PyXLL Add-in
Jupyter Notebooks in Excel »
  • Home
  • Product
  • Features
  • Documentation
  • Download
  • Pricing
  • Support
  • Documentation
  • Videos
  • FAQ
  • Learn Python
  • Contact Us
  • About
  • About Us
  • Legal
  • Blog
© Copyright PyXLL Ltd