/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

4 votes132 views1 answer
React typescript scss
TypeScript
38 votes172 views2 answers
Npm ng.ps1 cannot be loaded because running scripts is disabled on this system grepper
TypeScript
4 votes122 views2 answers
Typescript get type
TypeScript
1 vote129 views1 answer
Moving data between the request
TypeScript
1 vote134 views1 answer
Typescript add comments to interface prop[
TypeScript
3 votes136 views1 answer
Redux toolkit typescript install
TypeScript
2 votes147 views3 answers
Mat dialog disable close
TypeScript
12 votes131 views3 answers
Loop through string js
TypeScript
2 votes99 views2 answers
Python iterate object
TypeScript
0 vote134 views1 answer
Delphi call function from its name
TypeScript