I'm wondering what would be the best structure/setup to run my python scripts for other users? I have python scripts that modify/automate excel files using xlwings. For learning purposes and to get better I tried setting it up using FastAPI. So currently, I manually launch uvicorn through cmd and it launches a fastapi app that I can access via localhost. The site just accepts a file path and some extra information and when I hit run it runs a subprocess that runs another python script that actually does all the xlwings/excel work. This works fine for myself but I'm now trying to get my teammates to use it too. If I manually launch uvicorn they can access the site and run it but I want to decouple having to manually launch it myself (and also not have excel launch under my user every time someone uses it) I have tried setting it to run as a windows service but apparently that runs it on "Session 0" and excel can't run there because it doesn't have desktop access. I'm looking for ideas to make this work for my team, and if I need to completely change the architecture I don't mind, just looking for any ideas. Continue reading...
