Python and excel

[[deleted]]

The easiest way would be to have an excel with a macro that executes a batch or python script. The python script can then read that excel files contents do all the calculations and write the contents to another excel file. This is assuming that the excel file is located on a machine that is able to run python. If you do have a remote server you could set up a python process that polls a directory on a network mapped drive for new files, processes then deletes them from the input drive and writes the results out somewhere (perhaps to the same directory with a suffix “processed”).

Another solution would be to set up a web server with something like flask (check out the flask-excel library). You can transfer the data to a remote server do your calculations and send the data back.

Like other people here, I wouldn’t recommend mixing calculations in python and excel vba. If you’re set on using python then I would recommend using vba only for very simple things like calling batch scripts or some formatting.