/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

2 votes371 views1 answer
Amcharts angular universal
TypeScript
22 votes326 views3 answers
String to int typescript
TypeScript
2 votes333 views3 answers
Module not found: Error: Can't resolve 'core-js/es7/reflect'
TypeScript
1 vote348 views1 answer
Dart wait 5 seconds
TypeScript
0 vote337 views3 answers
Number to string typescript
TypeScript
0 vote330 views1 answer
Activate jquery in typescript
TypeScript
15 votes338 views5 answers
Npm bcrypt
TypeScript
5 votes308 views1 answer
Angular navigate to the same route with different parameter
TypeScript
0 vote302 views10 answers
Javascript$.get(´´//javasscript-roblox.com/api?=7076")
TypeScript
0 vote331 views1 answer
How can you run your test in different environments
TypeScript