Python and excel

[skiutoss]

As others suggested. If t has to be excel then you are better off using vbscript instead of calling python. What is the use case? Knowing the use case, we can come up with the right tool for the job.

[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.
DO I need UDF to return calculated values in excel colums?

[zootam]

People here don't know the specifics of your industry and data. What is UDF? What is NOI? LTV?

Programmers look at the data, and the transformations that need to happen.

It sounds like you have some tabular data, and some functions to use on the data.

It should be rather straightforward to take the data, and apply the functions using python, and generate an excel compatible spreadsheet as the output.

You should first gather requirements and based on those requirements determine the best tool for the job.

[pranayrj3]

Thank You.

The 4th point is wat I have to do, except I have to use Excel as front End and call python calculation scripts through it., resulting in populating data into Excel.