/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 vote293 views1 answer
Typescript allow object subset of interface
TypeScript
4 votes246 views1 answer
Typescript update
TypeScript
0 vote324 views1 answer
Error TS2307: Cannot find module '@angular/cdk/bidi'.
TypeScript
0 vote370 views1 answer
Git rebase two commits to one
TypeScript
2 votes377 views1 answer
Delete folder and its subfolders in python
TypeScript
0 vote288 views1 answer
Convert epoch to normal date | stripe | epoch
TypeScript
52 votes502 views6 answers
Length of an array javascript
TypeScript
0 vote341 views1 answer
Spilit with comma in ts
TypeScript
6 votes295 views4 answers
Console
TypeScript
0 vote312 views1 answer
Subscription' is deprecated
TypeScript