/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 vote144 views3 answers
Get local storage data in angular
TypeScript
0 vote176 views1 answer
10 digit mobile number validation pattern in javascript
TypeScript
0 vote123 views1 answer
Typescript allow object subset of interface
TypeScript
0 vote154 views1 answer
Property 'breakpoints' does not exist on type 'DefaultTheme'.ts(2339)
TypeScript
1 vote138 views1 answer
A function that prints all numbers from 0 - n Added together python
TypeScript
47 votes162 views6 answers
Angular date pipe
TypeScript
0 vote140 views1 answer
Environ 2.020.000 résultats (0,60 secondes) << Add Grepper Answer (a) Résultats de recherche Résultats Web
TypeScript
0 vote148 views1 answer
Typescript pick type from interface
TypeScript
-1 vote165 views1 answer
Type char typescript
TypeScript
0 vote155 views1 answer
Print file contents in git bash
TypeScript