What is Office Scripts?
While all Excel users have access to Script Lab, not everybody will have access to Office Scripts – yet. Since we already know it shares the Office.js approach to manipulating Excel through scripts, what is the difference between the two?
- While it is very similar to Script Lab, Office Scripts is slightly easier to use. For example, some of the boilerplate
async
calls and error-handling functions are hidden from us. - Office Scripts has a recorder to make notes of our actions in Excel and transcribe them into scripts. This is very useful for learning about Office.js in particular.
- Office Scripts comes pre-installed in Office 365 online – although it may need to be enabled by an administrator.
- It is easier to share scripts. While (like in Script Lab) the script sits outside the workbook, by adding a button to the worksheet, anybody who can see the Excel sheet can also see the script.
- Office Scripts is highly integrated with...