/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

7 votes310 views2 answers
How to download torrents in ubuntu
TypeScript
0 vote327 views1 answer
Destructuring props in styled-components
TypeScript
5 votes276 views2 answers
Javascript convert classes to arrays
TypeScript
0 vote296 views1 answer
Angular viewchild second parameter
TypeScript
6 votes324 views3 answers
Print elements in map java
TypeScript
0 vote298 views1 answer
@babel/preset-typescript
TypeScript
0 vote297 views1 answer
Typescript get object from localstorage
TypeScript
0 vote293 views1 answer
"Listed following are distinguishing characteristics of different end states of stars. Match these to the appropriate consequence of stellar death."
TypeScript
0 vote284 views1 answer
How to get the sheets no in excel package workbook in c#
TypeScript
4 votes314 views3 answers
Cors npm typescript
TypeScript