/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 vote276 views1 answer
ReturnType FunctionName(FormalParameterList) { Statements ; return ReturnValue; }
TypeScript
0 vote267 views1 answer
Latest unity version that supports 32 bit
TypeScript
2 votes254 views2 answers
React native elements button with icon
TypeScript
0 vote258 views1 answer
$clients = User::query()->where("type","client" )
TypeScript
1 vote257 views1 answer
Input elements should have autocomplete attributes (suggested: "current-password")
TypeScript
8 votes256 views1 answer
Styled components hover
TypeScript
0 vote269 views1 answer
C# get all elements from list
TypeScript
1 vote265 views2 answers
Multiple scatter plots in python
TypeScript
0 vote244 views1 answer
Add custom text after title of products on achive page
TypeScript
2 votes279 views2 answers
Count all results codeigniter
TypeScript