Integrating Excel with Python using xlwings

This video gives you an introduction into how you can go back and forth from Excel and Python using xlwings. The advantage of xlwings is that is we can combine the powers of Excel and Python. Every step that Excel is better, we use Excel. For anything that Python has more flexibility and power, we use Python!

Source