Utilize the power of python to upgrade your Excel functionalities. In this xlwings tutorial, I am going to show you, how to run Python(scripts) in an open Excel Workbook.

xlwings can leverage Python’s scientific packages (NumPy, Pandas, SciPy, sci-kit-learn, etc.) to write tools with Python instead of VBA.
At the end of this tutorial, I show you also some practical examples. Those examples will include plotting & updating stock market information, as well as interacting with APIs & return the result to Excel and even creating a PDF stock report.

However, in this tutorial, I will not cover how to execute a Python script from excel. I will make a separate video on this.

All files of the tutorial can be found here [Google Drive]:
👉 http://bit.ly/3qcfCRN​

xlwings Documentation:
https://docs.xlwings.org/en/stable/

Subscribe: https://www.youtube.com/channel/UCZjRcM1ukeciMZ7_fvzsezQ

#python #excel #xlwings