Automate Excel with Python and xlwings Part 2: Run Python Function in Excel

xlwings is an open-source library created by Zoomer Analytics to manipulate Microsoft Excel with Python. In my opinion, xlwings is probably one of the best libraries out there to interact with Excel application beside win32com.

In Part 2 of the tutorial, we will learn
1) How to install xlwings add-in so we can run Python program in Excel
2) How to call a Python program from Excel using RunPython function
3) How to create a function in python and use the function in Excel