/TypeScript/Script editor google sheets create new sheet

Script editor google sheets create new sheet

function onOpen() {
    var activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var yourNewSheet = activeSpreadsheet.getSheetByName("Name of your new sheet");

    if (yourNewSheet != null) {
        activeSpreadsheet.deleteSheet(yourNewSheet);
    }

    yourNewSheet = activeSpreadsheet.insertSheet();
    yourNewSheet.setName("Name of your new sheet");
}

Source: stackoverflow.com

Similar codes

0 vote138 views1 answer
How to check if something exists roblox
TypeScript
0 vote137 views1 answer
Cannot find module '@azure/msal-angular' or its corresponding type declarations.ts(2307)
TypeScript
0 vote123 views1 answer
Typescript delete value from map
TypeScript
0 vote145 views1 answer
Usage: testing_caption_generator.py [-h] -i IMAGE testing_caption_generator.py: error: the following arguments are required: -i/--image An exception has occurred, use %tb to see the full traceback.
TypeScript
0 vote126 views1 answer
Queryselectorall of multiple tags
TypeScript
0 vote137 views1 answer
Sum all elements using each_with_object ruby
TypeScript
1 vote232 views3 answers
Stripe create subscription
TypeScript
0 vote148 views1 answer
How to set date axes limits in matplotlib plot
TypeScript
1 vote106 views1 answer
Jquery selector id starts with and ends with
TypeScript
10 votes213 views1 answer
Expo.ps1 cannot be loaded because running scripts is disabled on this system. for more information
TypeScript