Office Scripts allow you to record your actions and generate the corresponding TypeScript code to allow the actions to be automated.
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.
All scripts can be saved to OneDrive for Business so they can be easily shared and used across different files.
Every script runs the code in a single main method.
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.
Office Scripts is not available in Internet Explorer
Only available to E3 and E5 licenses.
Only available in Excel on the web
Office Scripts cannot use the Common Shared API.
Office scripts do not support events.
link - techcommunity.microsoft.com/t5/excel-blog/announcing-office-scripts-preview/ba-p/1093559
link - support.microsoft.com/en-us/office/introduction-to-office-scripts-in-excel-9fbe283d-adb8-4f13-a75b-a81c6baf163a?ui=en-us&rs=en-us&ad=us
link - docs.microsoft.com/en-us/office/dev/scripts/
link - docs.microsoft.com/en-us/office/dev/scripts/overview/excel
link - docs.microsoft.com/en-us/office/dev/scripts/tutorials/excel-tutorial
link - github.com/OfficeDev/office-scripts-docs-reference/
link - github.com/OfficeDev/office-scripts-docs/
link - youtube.com/watch?v=94YYO3xiSOI
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopNext