/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 vote247 views1 answer
How can you run your test in different environments
TypeScript
38 votes301 views2 answers
Whats my ip
TypeScript
0 vote251 views1 answer
Absolute import typescript react
TypeScript
0 vote256 views1 answer
Dotcms elasticsearch query
TypeScript
0 vote266 views2 answers
Pywavelets tutorial
TypeScript
0 vote253 views1 answer
How to check whether url is responding or not in typescript
TypeScript
38 votes296 views2 answers
Npm ng.ps1 cannot be loaded because running scripts is disabled on this system grepper
TypeScript
1 vote239 views1 answer
Invalid formula - Operator ">=" doesn't support DATE >= TEXT. Operator ">=" supports ANY >= ANY
TypeScript
1 vote261 views1 answer
React native image picker launch camera example
TypeScript
0 vote222 views1 answer
How to print certain elements of an array
TypeScript