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
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
Function Documentation
Variable and Keyword Arguments
Recalculating On Open
Interrupting Functions
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
Pausing Screen Updates and Automatic Calculation
Keyboard Shortcuts
Real Time Data
Introduction
RTD Generators
Using the RTD Class
RTD Data Types
Restarting RTD Functions
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
Moving and Resizing
Custom Task Panes
PySide and PyQt
wxPython
Tkinter
Other UI Toolkits
ActiveX Controls
PySide and PyQt
wxPython
Tkinter
Other UI Toolkits
Resizing ActiveX Controls
Other Considerations
Using Pandas in Excel
Returning a DataFrame from a Function
Taking a DataFrame as a Function Argument
Returning Multiple DataFrames
Formatting DataFrames
Plotting DataFrames
Reading and Writing DataFrames in Macros
Passing as Python objects instead of Excel arrays
Pandas Series
Advanced usage of the Pandas type converters
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
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 »
