pyxll

.. -- mode: rst; ispell-local-dictionary: "en" --

.. $Id:$

Write Microsoft Excel Addins in Python

With PyXLL you can use Microsoft Excel as a user friendly front-end to your Python code. No VBA, just Python!

• Worksheet Functions (UDFs): Call your Python functions directly from Excel.
• Real Time Data: Stream real time data feeds from Python to Excel.
• Macros: Replace VBA code with Python.
• Menus and Toolbars: Add your own menus and ribbon toolbars to Excel.

PyXLL is a high performance and easy to use Python integration solution for Microsoft Excel.

For more details visit https://www.pyxll.com.

Installation

To use PyXLL the PyXLL Excel add-in needs to be installed.

Download the PyXLL Excel add-in from https://www.pyxll.com/download.html and see https://www.pyxll.com/docs/userguide/installation.html for detailed installation instructions.

This wheel contains the Python code needed to import the PyXLL module during development and testing, but it not needed when your code is running in Excel using the PyXLL add-in.

To install this package from pypi run pip install pyxll.

Features

For complete documentation and example code see the website https://www.pyxll.com.

Call Python Functions From Excel

Expose your analytics or modelling functions directly to Excel users. Any Python function can be turned into an Excel worksheet function, or User Defined Function (UDF).

• Interactive modelling, analysis and ad-hoc calculations
• Build dashboards using Python functions
• Source data from your existing systems
• Faster calculation times than VBA

Macros, Menus and Ribbon Tabs

Automate Excel using macros, menu items, custom ribbon tabs and context menus, entirely in Python.

• Use Excel instead of building your own UI
• Bind macros to on-sheet buttons and other elements
• Full control of the ribbon with Python actions
• No VBA required, automate Excel with Python

Real Time Data

Stream live market data into your spreadsheets in real-time.

• Make auto-updating dashboards with live data
• Source real time data from anywhere with Python
• Use Python's asyncio event loop or your own threads
• No complicated setup required

Lightning Fast Object Cache

Pass Python objects directly between Excel worksheet functions for cleaner and faster workbooks.

• No need to always expand large arrays in Excel
• Reduce spreadsheet clutter by returning objects in a single cell
• Pass returned Python objects to other Python functions
• Avoid time wasted reconstructing objects

Frictionless Developer Experience

Use any Python distribution (including Anaconda) and your preferred Python IDE or editor.

• All code is external to Excel so is easily managed and deployed
• Debugging support for all major Python IDEs
• Reload automatically or manually, without restarting Excel
• Code can be run and tested outside of Excel

For more details see https://www.pyxll.com/features.html.