Excel Online has Typescript-based [1] automation with Office Scripts [2]. There's even an online VS Code-based editor in development [3]. You can run these scri

Excel Online has Typescript-based [1] automation with Office Scripts [2]. There's even an online VS Code-based editor in development [3]. You can run these scripts non-interactively in Power Automate and integrate with pretty much anything, it's all pretty powerful. [1] https://learn.microsoft.com/en-us/office/dev/scripts/develop/typescript-restrictions https://learn.microsoft.com/en-us/office/dev/scripts/develop... [2] https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel https://learn.microsoft.com/en-us/office/dev/scripts/overvie... [3] https://learn.microsoft.com/en-us/office/dev/scripts/develop/vscode-for-scripts https://learn.microsoft.com/en-us/office/dev/scripts/develop...