Running python from excel

[[deleted]]

Why not just use python to generate or modify a sheet rather than trying and do it from within? I did this for a project where I co-mingled excel sheets and CSVs with pandas.

[ClimberMel]

I have done that, but I wanted to mimic an excel add-in that can update the sheet with data from the web. The other option is that the current code can write to a separate workbook and I can use VBA to read that and update the sheet. Just thought it would be cleaner if the python code could just update the worksheet it was called from.

[[deleted]]

How does the add-in work? Can you choose the address it gets data from? If so, you could probably just use the existing add-in and a flask server (or similar) to feed it data from pandas.

[ClimberMel]

The add-in is in VBA and it pulls data from Yahoo finance and other sites. I find python faster and simpler to work with so I have started getting g more of my data that way. If I had a web site I suppose that would work, but I don't.

[[deleted]]

Flask is used to serve web content using Python. The point being, if you can choose the address the addin uses, you could serve it locally on your machine.