/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 vote101 views1 answer
Target.value typescript
TypeScript
1 vote125 views1 answer
How to make a button that alerts when clicked with html
TypeScript
0 vote95 views1 answer
How to add id in array javascript
TypeScript
0 vote95 views1 answer
Typeerror: cannot read property 'initialize' of undefined passport
TypeScript
1 vote97 views1 answer
:= and = in gdscript
TypeScript
0 vote235 views1 answer
Git rebase two commits to one
TypeScript
0 vote116 views1 answer
Automation strategy of manual test cases
TypeScript
20 votes102 views2 answers
Install ng bootstrap
TypeScript
6 votes111 views5 answers
Convert HTMLCollection to array
TypeScript
0 vote104 views4 answers
Typescript class inheritance
TypeScript