Office Scripts is generally available. Office Scripts is an automation feature-set in Excel for the Web that allows users with all levels of programming experience to automate their repetitive workflows.
Basically, if you regularly acquire an Excel spreadsheet that you need to reformat (hiding columns, set conditional formatting on cells, add charts, etc.):
- Office Scripts can record the settings you apply.
- The script is saved to OneDrive.
- The user can edit the script directly within Excel for the Web using the built-in Code Editor
- The script can be rerun on on future spreadsheets, applying all your formatting & changes
Office Script is available for Office 365 E3/E5. (Note: Office Scripts is not available for GCC/non-commercial clouds & there is no immediate roadmap – yes, I’ve pinged the Program Manager)
For a demo on how this is done:
- VIDEO: What’s new in Office Scripts for Excel on the web
https://www.youtube.com/watch?v=94YYO3xiSOI
Read more about the release here:
- RELEASE: Office Scripts is now generally available
https://techcommunity.microsoft.com/t5/excel-blog/office-scripts-is-now-generally-available/ba-p/2352548 - DOCS: Office Scripts documentation – Office Scripts
https://docs.microsoft.com/en-us/office/dev/scripts/
kurtsh
Kurt Shintaku's Blog 