/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

1 vote182 views1 answer
Ionic copy to clipboard
TypeScript
0 vote173 views1 answer
Scripted testing and exploratory testing
TypeScript
1 vote173 views1 answer
Typing in typescript
TypeScript
0 vote183 views1 answer
How to set date axes limits in matplotlib plot
TypeScript
1 vote234 views1 answer
Cannot find module 'file-saver/FileSaver' or its corresponding type declarations.
TypeScript
0 vote186 views1 answer
Piechart am4charts legend with actual values
TypeScript
0 vote171 views1 answer
Take two inputs from user and add them using callback function
TypeScript
0 vote213 views1 answer
Event
TypeScript
1 vote171 views1 answer
Next js onclick navigate
TypeScript
0 vote179 views1 answer
Remove showing results woocommerce shortcode
TypeScript