/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 votes304 views1 answer
State in react typescript
TypeScript
0 vote312 views3 answers
Highcharts cdn links
TypeScript
0 vote277 views1 answer
Coding Exercise: Double Time Modify this recursive program to correctly count down in increments of 2.
TypeScript
5 votes337 views3 answers
Jquery id that starts with
TypeScript
1 vote295 views3 answers
Linux split mp4 into 2 parts by time
TypeScript
0 vote301 views1 answer
Access single document with its id flutter
TypeScript
7 votes302 views5 answers
Reactnative typescript
TypeScript
8 votes309 views1 answer
Split list into lists of equal length python
TypeScript
1 vote275 views1 answer
Replace \n with breakline in type scripte
TypeScript
2 votes287 views2 answers
Date format in typescript
TypeScript