/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

13 votes178 views3 answers
Typescript integer
TypeScript
52 votes504 views6 answers
Length of an array javascript
TypeScript
0 vote135 views4 answers
Error: The method assertThat(T, Matcher<? super T>) in the type MatcherAssert is not applicable for the arguments (List<String>, Matcher<Iterable<Integer>>)
TypeScript
1 vote228 views1 answer
Useappselector
TypeScript
0 vote179 views1 answer
Terminal prompts disabled
TypeScript
1 vote351 views2 answers
Ngfor ionic example
TypeScript
2 votes184 views1 answer
Type casting in typescript
TypeScript
18 votes180 views3 answers
What is unit testing
TypeScript
0 vote213 views5 answers
How to css after elements for background overlays
TypeScript
1 vote191 views1 answer
Typescript while
TypeScript