/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 vote118 views1 answer
Cats internet cafe 18 hr
TypeScript
0 vote109 views1 answer
How to compile automatically in typescript
TypeScript
7 votes120 views3 answers
How to find how many commits i have done
TypeScript
0 vote120 views1 answer
Symfony assets install
TypeScript
0 vote166 views1 answer
Typeorm where in example
TypeScript
0 vote120 views1 answer
What is hello world in typescript
TypeScript
19 votes112 views3 answers
Random between two floats python
TypeScript
0 vote125 views1 answer
Display Popular Posts laravel
TypeScript
0 vote121 views1 answer
Java delete contents of file
TypeScript
0 vote115 views1 answer
Typescript foreach object ts(7053)
TypeScript