/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 vote249 views1 answer
React native image picker launch camera example
TypeScript
1 vote235 views1 answer
Ng-select disabled
TypeScript
0 vote248 views1 answer
Import xml elements in kotlin
TypeScript
0 vote254 views1 answer
Increment all elements list python
TypeScript
0 vote231 views1 answer
Components of cucumber bdd framework
TypeScript
1 vote237 views2 answers
How to sort numbers in typescript
TypeScript
1 vote258 views1 answer
(change) on select not working in mat-select
TypeScript
0 vote232 views1 answer
Empty string in typescript
TypeScript
0 vote233 views1 answer
Mongodb find documents where two fields are equal
TypeScript
1 vote265 views1 answer
Get all documents in collection firestore flutter
TypeScript