/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 vote138 views1 answer
Nmap to find open ports kali linux
TypeScript
0 vote120 views1 answer
Go Array’s length is part of its type.
TypeScript
0 vote121 views1 answer
Java 8 collect multiple lists into single list
TypeScript
0 vote125 views1 answer
Join all lists in list python
TypeScript
0 vote132 views1 answer
Input type file in html events angular
TypeScript
13 votes144 views5 answers
Useref react typescript
TypeScript
3 votes129 views1 answer
Parsing error: "parserOptions.project" has been set for @typescript-eslint/parser.
TypeScript
0 vote124 views1 answer
How to medrge lists of lists
TypeScript
0 vote135 views1 answer
How to send attachments to node mailer file not found
TypeScript
0 vote128 views1 answer
Whats app link target blank
TypeScript