Python for Excel
Excel and Python are both super popular technologies. In this session, Felix will show you why they are even more powerful when used together: using Python and pandas DataFrames with Excel can replace Excel’s fragmented automation and data analysis languages (VBA, M, and DAX) and opens the door for running things outside of Excel, too.
About the Speaker
Felix is the creator of xlwings, an open-source Python package that allows you to automate Excel with Python. He is also the author of the book “Python for Excel” (O’Reilly 2021). The mission of his company is to provide a sane and innovative infrastructure around Excel workbooks. This also includes xltrail, a version control system for Excel workbooks.