PyXLL

PyXLL is an Excel add-in that enables you to extend Excel using nothing but Python code. Customize Excel by adding worksheet functions, macros and menus. With access to the entire Python ecosystem you can write expressive, effective and efficient code to solve your business and data science problems and expose it to Excel either for yourself or for other Excel users in your organization. Use any Python version from any vendor (from python.org, Enthought Canopy, Ananconda, Portable Python or any other CPython distribution) with any Excel version (32 and 64 bit). PyXLL supports worksheet functions (UDFs), macro functions, menus, ribbon customization, real time data (RTD) functions, array functions and everything else you need to write Excel addins all in Python.