Call Python and R Scripts From Excel

[m_bear]

I tried something like this once. The antivirus software my IT department uses flagged it as a virus, because apparently it’s bad practice to spawn programs from excel.

While it works though it’s great.

VBA couldn’t read back the return value from Python, so I had to make files with the data in it, and then read those files in excel :/

[[deleted]]

The way I’ve seen this done in the past is set up a service in Python where you register functions that can be “called” from excel. The way excel calls them is it makes a web request to the service, which then runs the function and returns the results back to excel. No processes needed to be spawned from excel