xcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA.
Is your email address OK? You are signed up for our newsletters but your email address is either unconfirmed, or has not been reconfirmed in a long time. Please click here to have a confirmation email sent so we can confirm your email address and start sending you newsletters again. Alternatively, you can update your subscriptions.
Introduction
ExcelPython is a lightweight COM library which enables you to call Python code and manipulate Python objects from Excel VBA (or indeed any language supporting COM). In this article I will show you how this is done.
Background
Though its supremacy is being challenged by free (OpenOffice) or cloud (Google Sheets) alternatives, Excel remains the most widely used application for user-friendly computation and data processing in an office environment. Being able to call Python code from Excel vastly expands Excel's capabilities by leveraging the vast collection of libraries and powerful language features.
ExcelPython is an in-process COM library which enables you to load Python modules, call methods and manipulate objects. Other Python/Excel interfaces, such as PyXLL and Python-Excel, which are both excellent tools, differ from