/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 vote115 views1 answer
Could not read Username for 'https://github.com': terminal prompts disabled
TypeScript
1 vote110 views1 answer
Ts class static function call inside class extends
TypeScript
2 votes128 views2 answers
Vs code ahk folding
TypeScript
0 vote98 views1 answer
How to make a dictionary of indices and lists python
TypeScript
4 votes111 views2 answers
Command line arguments in java
TypeScript
0 vote111 views1 answer
Return from r in restaurants orderby r.Name select r c#
TypeScript
1 vote112 views1 answer
What is the name of belt around the orbits of earth and mars
TypeScript
11 votes108 views2 answers
React tsx component example
TypeScript
12 votes128 views4 answers
Google fonts poppins
TypeScript
0 vote109 views1 answer
Angular TS2377
TypeScript