Introduction to adding worksheets in Office Scripts.
The following syntax is used
The method argument does not have to be, but the sheet name can be specified. (Red text indicates a variable portion.)
workbook.addWorksheet("Sheet name to be added");
The added sheets can also be assigned to variables.
You can also use that sheet variable to set values, etc.
variable name = workbook.addWorksheet();
For those who want to learn Office script effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Excel Office Script to streamline your workflow.