/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 vote208 views1 answer
How to find specific elements from a list in java
TypeScript
0 vote195 views1 answer
How can i take multiple inputs from the user in discord.js
TypeScript
1 vote274 views1 answer
Nextjs global prisma
TypeScript
0 vote187 views1 answer
How to combine pdf documents C#
TypeScript
0 vote228 views3 answers
Cahokia mounds pictures
TypeScript
0 vote166 views1 answer
Error TS2339: Property 'open' does not exist on type 'MatDialogModule'.
TypeScript
2 votes163 views1 answer
Socketi io client disconnect
TypeScript
3 votes172 views2 answers
Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.
TypeScript
11 votes168 views1 answer
How to remove dots in ul li
TypeScript
0 vote167 views1 answer
The Android Gradle plugin supports only Kotlin Gradle plugin version 1.3.40 and higher. The following dependencies do not satisfy the required version: project ':video_compress' -> org.jetbrains.kotlin:kotlin-gradle-plugin:1.3.31
TypeScript