Python for Excel

Despite big data, AI and the block chain, Excel workbooks are not going anywhere anytime soon. In his talk, Felix demonstrates the possible ways of using Python to interact with Excel and shows how you can leverage the Python ecosystem for different use cases. He also shows that by applying programming best practices (like unit tests and version control) to Excel workbooks, you can massively improve the security and reliability of spreadsheets.

speaker photo

Felix Zumstein

Felix is the creator of xlwings, an open-source Python package that allows you to automate Excel with Python. xlwings also acts as drop-in replacement for VBA, thereby giving you access to Python's rich & modern ecosystem for data science and machine learning. 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.

zobacz nagranie