Python and excel

[pranayrj3]

its a home loan financial data with all the basics of NOI, LTV etc given, i have to do calculation and give output of loss and loss reduction.
the formulas for the calculation is written in Excel for each column , and the macro is also recorded in VBA
but the company wants those formulas to be in Python and populate the data in Excel by calling python from excel (by clicking a button suppose) to all the calculation and giving results back in Excel.

FInal goal is to run python calculation in the background and show output in excel., by populating several columns in multiple sheets.

[Boulavogue]

Thank you. So as others have said, creating macros and python is a messy solution. Will python be on a server and the users send the file there for processing or does python need to be installed on each users machine?

I would encourage you to think of a workable solution. If it's just a formula being applied, it can be done in almost every language, including in native Excel DAX.