/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 vote186 views1 answer
Code to check if a triangle is valid or not
TypeScript
-1 vote166 views1 answer
I comparer for lists c#
TypeScript
-2 votes172 views3 answers
Typescript count array condition
TypeScript
1 vote163 views1 answer
How to add elements to Jlist
TypeScript
5 votes158 views1 answer
Heroku database error unknow attribute first_name for user
TypeScript
0 vote189 views2 answers
How to set value to readonly property in typescript
TypeScript
0 vote189 views1 answer
How to update firebase document field angular
TypeScript
0 vote188 views1 answer
Online ts compiler
TypeScript
0 vote186 views2 answers
Is subscribing to a lot of events in ngonint bad
TypeScript
2 votes194 views1 answer
TypeError: default_collate: batch must contain tensors, numpy arrays, numbers, dicts or lists; found <class 'PIL.Image.Image'>
TypeScript