XLwings works locally on my Windows machine, but if I try to run it remotely on a SageMaker instance (which I believe uses Linux under the hood) it doesn't work. What do I need to do to enable this?
Code is:
wb = xw.Book('my_excel_file.xlsx')
Which results in the following error:
XlwingsError: Your platform only supports the instantiation via xw.Book(json=...)
I'm planning on using XLwings to automatically run an excel model for me (update inputs, run model, save outputs) and I don't think this would be possible if converted to JSON - and I can't find anything in the docs to help me either. Appreciate the help!
Many thanks!