/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

1 vote187 views1 answer
Mongodb array size greater than
TypeScript
0 vote241 views1 answer
Error TS2503: Cannot find namespace 'google'. 10 @Input() mapOptions: google.maps.MapOptions;
TypeScript
0 vote151 views1 answer
Using method parameters in a guard nestjs
TypeScript
1 vote159 views1 answer
Class-validator validate nested object
TypeScript
21 votes155 views2 answers
Typescript array insert
TypeScript
0 vote167 views1 answer
"ValueError: Solver lbfgs supports only 'l2' or 'none' penalties, got l1 penalty." in machine learning
TypeScript
0 vote151 views1 answer
Real time charts in flutter
TypeScript
1 vote148 views1 answer
Return the Objects Keys and Values
TypeScript
1 vote140 views1 answer
"send" and "transfer" are only available for objects of type "address payable", not "address".
TypeScript
1 vote162 views1 answer
Typescript how to add a property to an object
TypeScript