Office Scripts

Office Scripts allow you to record your actions and generate the corresponding TypeScript code to allow the actions to be automated.
TypeScript is a superset of JavaScript.
This feature is equivalent to the VBA Macro Recorder.


Once this feature has been enabled within the Office 365 environment you will see an additional Automate tab appear at the top.


Link - https://techcommunity.microsoft.com/t5/excel-blog/announcing-office-scripts-preview/ba-p/1093559
Link - https://docs.microsoft.com/en-us/office/dev/scripts/
Link - https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel



All scripts can be saved to OneDrive for Business so they can be easily shared and used across different files.
Office Scripts were first introduced in Developer Preview in January 2020.
Office scripts do not support events.
Every script runs the code in a single main method.
It is not possible to register events or take action when events are triggered.


Office Scripts cannot use the Common Shared API.
You cannot undo the effect of an Office Script.
The version history of the file should be used as an alternative.


You can turn on the logging console by pressing the Ellipses button and select Logs.


Remarks

Office Scripts is not available in Internet Explorer
Only available to E3 and E5 licenses.
Only available in Excel on the web



© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopNext