Combining Excel and Python using xlwings - Combining Excel and Python смотреть онлайн

Combining Excel and Python using xlwings

Part of the lecture series "Combining Excel and Python":
https://nickderobertis.github.io/fin-model-course/lectures/9-combining-excel-and-python

Full Course Website:
https://nickderobertis.github.io/fin-model-course/


Notes
--------

- xlwings is a package that makes it quite easy to combine Excel and Python in ways that should work for nearly every use case
- This can be done without xlwings using the Microsoft COM API in Python, but xlwings is far more convenient
- We are focusing here on only manipulating Excel from Python, but I encourage you to explore running Python from Excel on your own time
- Now with xlwings, anything that you can do in Excel, you can make it happen from Python
- It is easy to transfer individual values, ranges, and tables back and forth between Excel and Python
- For those who have a lot of difficulty with Python and feel comfortable in Excel, xlwings allows building out the core model in Excel and adding extensions such as Monte Carlo simulation, sensitivity analysis, and scenario analysis in Python

Resources
------------

- Combining Excel and Python: https://nickderobertis.github.io/fin-model-course/_static/Examples/Connecting%20Python%20and%20Excel/xlwings/Combining%20Excel%20and%20Python.ipynb
- Example Workbook: https://nickderobertis.github.io/fin-model-course/_static/Examples/Connecting%20Python%20and%20Excel/xlwings/Example%20Workbook.xlsx
- xlwings Lab: https://nickderobertis.github.io/fin-model-course/_static/Materials%20for%20Lab%20Exercises/Connecting%20Python%20and%20Excel/xlwings/xlwings%20Lab.xlsx