/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

3 votes106 views1 answer
Google chrome extensions content scripts matches
TypeScript
0 vote107 views1 answer
Angular material date picker add dates automatically
TypeScript
12 votes117 views3 answers
Python count number of digits in integer
TypeScript
0 vote112 views1 answer
Typeorm data array from relation
TypeScript
2 votes133 views1 answer
Typescript singleton
TypeScript
2 votes99 views3 answers
Getserversideprops
TypeScript
9 votes107 views5 answers
Array of objects typescript
TypeScript
4 votes154 views1 answer
Require('dotenv').config() typescript
TypeScript
0 vote105 views4 answers
Convert .js file to ts
TypeScript
2 votes106 views1 answer
Check if file exists laravel
TypeScript