xlwings is an open-source Python package that connects Excel with Python on Windows and Mac. It allows for interactive use from IPython Notebooks or any other Python environment but also allows to run Python code from Excel as replacement for VBA macros.
The talk will give an overview of the current Excel/Python landscape, show the characteristics of the xlwings package and include a live demo to show how easy the usage is. The demo will also include examples of tasks that would otherwise be difficult to do with Excel only as well as more real world tools built with Python where Excel merely acts as a user interface/frontend.
Felix Zumstein is founder of Zoomer Analytics and creator of xlwings, a free and open-source package that connects Excel with Python, a powerful programming language. Previously, he was a director at UBS Global Asset Management in Zurich where he was responsible for building an in-house system to analyze and optimize the strategic asset allocation of institutional and private clients. He holds a Master’s degree in Finance and Economics from the University of St.Gallen and is a CFA charterholder.