/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 vote295 views1 answer
Local Variable in Jenkins
TypeScript
0 vote248 views1 answer
Can only use lower 16 bits for requestCode registerForActivityResult
TypeScript
0 vote270 views1 answer
Combine results from two columns in ms sql
TypeScript
0 vote338 views1 answer
Reorder inline-block elements css
TypeScript
61 votes479 views6 answers
Ps1 cannot be loaded because running scripts is disabled on this system
TypeScript
0 vote276 views1 answer
How to Write a program that accepts three decimal numbers as input and outputs their sum on python
TypeScript
0 vote430 views1 answer
Warning: format ‘%s’ expects argument of type ‘char *’, but argument 2 has type ‘int’
TypeScript
0 vote269 views1 answer
Typescript file cannot find module vue
TypeScript
1 vote271 views1 answer
Git writing objects slow
TypeScript
39 votes338 views6 answers
React typescript create react app
TypeScript