An open-source Python library that makes it easy to call Python from Excel and vice versa. It allows scripting Excel with Python and creating Python-based UDFs.
XLwings
- Excel
- AI and Machine Learning, Automation, Data Analytics, Mathematics, Simulation
- Artificial Intelligence (AI), Machine Learning, Open Source, Software, Software Development Kit (SDK), User Interface (UI)
Features:
- Automate Excel with Python, write User Defined Functions (UDFs) in Python, control Excel via Python scripts, use Python libraries (NumPy, Pandas, Matplotlib, scikit-learn) with Excel, embed Matplotlib plots in Excel, real-time data streaming
Pricing:
- Free
- Free and open-source, powerful for automating Excel and extending its capabilities with Python, enables leveraging the entire Python scientific stack, good for developers and data scientists who prefer Python.
- Requires Python installation and some Python knowledge, UDF performance for very frequent calls can be a concern (though improvements are ongoing), deployment of solutions can be more complex than self-contained VBA.
Best for:
- Python developers, data scientists, and analysts who want to control, automate, and extend Microsoft Excel using Python, leveraging its rich scientific and data analysis libraries.