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
Worksheet Functions
¶
Introduction
Writing an Excel Worksheet Function in Python
Configuring PyXLL with your Python Module
Calling your Python Function from Excel
Different Argument and Return Types
Argument and Return Types
Specifying the Argument and Return Types
@xl_func Function Signature
Python Type Hints
@xl_arg and @xl_return Decorators
Type Parameters
Standard Types
Array Types
The ‘var’ Type
Numpy Types
Pandas Types
Polars Types
Dictionary Types
Dataclass Types
Union Types
Optional Types
Function Type
Error Types
Using Python Objects Directly
Custom Types
Manual Type Conversion
Cached Objects
Example
Accessing Cached Objects in Macros
Populating the Cache On Loading
Saving Objects in the Workbook
Custom Object Handles
Mixing Primitive Values and Objects
Clearing the Cache on Reloading
Array Functions
Array Functions in Python
Array Types
Ctrl+Shift+Enter (CSE) Array Functions
Auto Resizing Array Functions
Dynamic Array Functions
NumPy Array Types
Pandas Types
Type Annotations
Type Parameters
Polars DataFrames
Type Annotations
Type Parameters
Asynchronous Functions
Asynchronous Worksheet Functions
The asyncio Event Loop
Before Python 3.5
Function Documentation
Variable and Keyword Arguments
Variable Arguments (*args)
Keyword Arguments (**kwargs)
Recalculating On Open
Use-Cases
Example
Default Behaviour
Disabling Completely
Interrupting Functions
« Shortcuts
Introduction »
