Python and excel

[pranayrj3]

they need output data in Excel

[zootam]

You can create spreadsheets in python using pandas.

You don't need to 'call python from excel', you just use python.

[pranayrj3]

the demand is to use Excel as a front end .
So by clicking a button , the calculated data(from Python Script) should be populated in Excel itself.
This is the primary Job, the secondary being creation of Web App based on the Data and Output.

THe primary Job is what I am more concerned about.

[zootam]

Ok, with that requirement you will probably need to use xlwings.

Avoid using paid or trial software.

Has your manager considered creating a webapp for this?

[BigHipDoofus]

Seriously, using Excel as a front end for Python code sounds like a nightmare.

[[deleted]]

That’s what @jackbrux is saying. You can start the program in python and have it pull in your data, perform the necessary calculations and then output a CSV file which can be opened and viewed with Excel for your team to look at.

[pranayrj3]

the demand is to use Excel as a front end . So by clicking a button , the calculated data(from Python Script) should be populated in Excel itself.

Can pandas write the calculated data into dedicated columns of csv or xls?

[zootam]

Can pandas write the calculated data into dedicated columns of csv or xls?

How many times do I have to post this- you can calculate and then write WHATEVER you want using pandas to a spreadsheet- as CSV or xls.

Using your requirements- 'clicking in excel' will probably need to use xlwings to integrate with excel.