/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

14 votes162 views4 answers
Typescript convert color to rgb
TypeScript
2 votes170 views5 answers
Ng class in angular
TypeScript
0 vote157 views1 answer
How to add new row to a particular index of a ag grid using angular 7
TypeScript
0 vote156 views1 answer
Swalert 2 show loader
TypeScript
0 vote172 views1 answer
Android get digits from string
TypeScript
2 votes171 views2 answers
Props vue typescript
TypeScript
0 vote180 views1 answer
Testing with limited information
TypeScript
1 vote188 views1 answer
Psycopg2 OperationalError: FATAL: unsupported frontend protocol 1234.5679: server supports 2.0 to 3.0
TypeScript
0 vote165 views1 answer
Typescript cast to type remove properties
TypeScript
-1 vote179 views1 answer
Laws of UX: Using Psychology to Design Better Products & Services pdf
TypeScript