/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 vote190 views1 answer
Cmd move file to parent folder
TypeScript
1 vote273 views1 answer
Property 'result' does not exist on type 'EventTarget'
TypeScript
0 vote255 views1 answer
Breaks_width in r
TypeScript
-1 vote249 views1 answer
Drupal
TypeScript
2 votes243 views1 answer
Tweepy stream tweets from user
TypeScript
0 vote243 views1 answer
Separate subplots in python
TypeScript
1 vote311 views1 answer
Dataframe value counts sort
TypeScript
2 votes251 views2 answers
String to date in typescript
TypeScript
2 votes255 views2 answers
Typeorm find orderby
TypeScript
0 vote255 views1 answer
Android get digits from string
TypeScript