I have a scenario in which I have the output data ( after processing ) in Python. Is there any way by which i can pass this to built in Excel functions on the worksheet?
For e.g. I have 100 values of data at python layer, Now when i use "=MAX()" function and pass some appropriate argument it should find the maximum of the 100 values. In other words, i am trying to leverage the Excel functions to operate on data from python.
The only way i could think of is to write all the data into excel worksheet, and then the user should use excel function just like any other spreadsheet data. But I am trying to find a better solution where i can avoid writing all the data on to the spreadsheet.
can you please let me know if you think there is any way of achieving this?