I have a use case where I want to automate and interface an Excel model from The workflow would be something like:
- Transfer data from Python to Excel
- Execute macro to run model model to convergence (about 45secs)
- Wait for macro to a cell statues indicating completion.
- Collect the data from Excel and post-process in Python
Can I do this with xlwings or any other Excel interface library?