4 ms·
The only thing that Google Sheets has in their favor, is their JavaScript API to interact with the sheets. But even that is fairly slow compared to any scripti
by XzAeRosho 3y ago
The only thing that Google Sheets has in their favor, is their JavaScript API to interact with the sheets.
But even that is fairly slow compared to any scripting done in Excel.
- ryanjshaw 3y agoExcel 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...