I'm an analyst which automate stuff, currently i havea sheet of excel with a like calculator and a xlwings script with python that automates that process, i want to exapnd it more in my organization and xlwings seems to get stuck some times and not as reliable because of using com objects. I've thought about sending the parameters through an API with Excel/google sheets and than call the output from the API after the parametrers passed using python for caluclation is better, but my team are working with sheets programs, (google sheets or excel) and we change the calculator daily) I think the best option would be - read parameters from SQL - send through to API to a calculator in excel/google Sheets and then output the calculations back to the database (the output) - all this while the script waits for response. how can i do it ? is it a smart flow? Continue reading...
