- Write Excel worksheet functions in Python
- Functions are automatically included in the Excel Function Wizard with their python docstrings
- Add menu items to Excel from Python
- Write Excel macros in Python
- Support for large array types in Excel 2007 and 2010
- Unicode support in Excel 2007 and 2010
- Asynchronous functions in Excel 2010
- Compatible with cPython modules compiled with SWIG, Boost, Cython etc.
- Reload and test without restarting Excel
- Stubs pyxll module provided to allow PyXLL code to be used outside of Excel (for unit testing etc.)
- Built-in support for numpy datatypes
- Customizable type system for handling non-standard datatypes
- Use win32com for calling back into Excel from PyXLL modules and for Excel event handling
Why use PyXLL?
- Increase productivity by using a modern dynamic language
- Leverage your existing Python code base
- Reduce risk by storing code in your version control system instead of embedded in Excel files
- Deploy changes more easily as the PyXLL addin just references your Python modules from the filesystem
- Reduce coding iteration cycles by removing the compile-and-restart step usually associated with C++ addins
- Get better performance using numpy and your own optimized cPython modules
If that’s got you interested go to the download page to download an evaluation version of PyXLL complete with example code to help get you started.