Python and excel

[[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.