xlwings - connecting python with excel
DESCRIPTION
xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa: Interact with Excel from Python using a syntax that is close to VBA yet Pythonic. Replace your VBA macros with Python code and still pass around your workbooks as easy as before. xlwings fully supports NumPy arrays and Pandas DataFrames.TRANSCRIPT
xlwings: Connecting Python with Excel
Python for Quant Finance Meetup, London
10 June 2014 Felix Zumstein
8 Years in Banking
Startup (Feb 2014)
About Me
2
Other Solutions to the same Problem • Proprietary solutions – PyXLL – DataNitro
• Microsoft’s solution – Pyvot (open-source but hosted on codeplex...)
• Others: – ExPy – Pyinex – ExcelPython – XLLoop
3
xlwings: The upside • Easy syntax: Close to VBA yet Pythonic.
• Easy deployment: No add-in required. Not even an existing Python installation.
• Easy debugging: Directly from within Python.
• Focus on datastructures that matter: NumPy arrays and Pandas DataFrames.
• Technically simple: Works with pretty much every combination of Python, Excel and Windows.
• Works with your favorite environment: Cmd, IPython, Spyder, PyCharm etc.
• It’s BSD licensed, on GitHub and part of Anaconda 2.0
4
xlwings: The downside • Overhead: Each call relies on the COM interface
through pywin32 and the Command Prompt • No UDFs • It’s still v0.1.0: So expect a few bugs and API changes
(but also tons of new features...)
5
Demo http://xlwings.org
6