Product
Features
Get Started
Request Demo
Pricing
Resources
Blog
Videos
Documentation
FAQ
Download
Customer Portal
About Us
Support
Documentation
Videos
FAQ
Contact Us
Contact Us
User Guide
¶
New to PyXLL? Start with our
First Time Users Guide
!
Installing PyXLL
First Time Users
PyXLL Command Line Tool
Manual Installation
Using PyXLL with Anaconda
Configuring PyXLL
Python Settings
PyXLL Settings
License Key
Logging
Warnings
Configuration Variables
Environment Variables
Startup Script
Menu Ordering
Shortcuts
Worksheet Functions
Introduction
Argument and Return Types
Cached Objects
Array Functions
NumPy Array Types
Pandas Types
Polars DataFrames
Asynchronous Functions
Handling Errors
Function Documentation
Variable and Keyword Arguments
Recalculating On Open
Interrupting Functions
Real Time Data
Introduction
RTD Generators
Using the RTD Class
RTD Data Types
Throttle Interval
Starting RTD Functions Automatically
Cell Formatting
Formatting Worksheet Functions
Pandas DataFrame Formatting
Custom Formatters
Formatting in Macros Functions
Charts and Plotting
Matplotlib
Pandas
Plotly
Seaborn
Bokeh
Altair
Others
Plotting from Worksheet Functions
Plotting from Menus, Macros and Elsewhere
Resizing and Replotting
Custom User Interfaces
PySide and PyQt
wxPython
Tkinter
Other UI Toolkits
Using Pandas in Excel
Pandas Types Options
Passing as Python objects instead of Excel arrays
Using the Pandas type converters outside of a UDF
Customizing the Ribbon
Introduction
Creating a Custom Tab
Action Functions
Using Images
Modifying the Ribbon
Merging Ribbon Files
Context Menu Functions
Introduction
Adding a Python Function to the Context Menu
Creating Sub-Menus
Dynamic Menus
References
Macro Functions
Introduction
Exposing Functions as Macros
Calling Macros From Excel
Calling Excel from Python
Reading Excel Values from Python
Writing Python Values to Excel
Keyboard Shortcuts
Working with Tables
Writing a Table
Reading a Table
Updating a Table
Tables and Worksheet Functions
Advanced Features
Python as a VBA Replacement
The Excel Object Model
Accessing the Excel Object Model in Python
Differences between VBA and Python
Enums and Constant Values
Excel and Threading
Notes on Debugging
Menu Functions
Custom Menu Items
New Menus
Sub-Menus
Reloading and Rebinding
Introduction
How to Reload PyXLL
Deep Reloading
Rebinding
Error Handling
Introduction
Standard Error Handlers
Custom Error Handlers
Deploying your add-in
Sharing everything on a network drive
Using a standalone zip file
Building an installer
Using a common pyxll.cfg file
Using a startup script to install and update Python code
Deploying the Python Environment
Adding the PyXLL add-in to Excel
Setuptools Entry Points
Workbook Metadata
« Introduction to PyXLL
Installing PyXLL »