/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 votes197 views1 answer
Tweepy stream tweets from user
TypeScript
0 vote203 views1 answer
Which Protect Presentation option protects a presentation from accidental changes:
TypeScript
68 votes544 views6 answers
Python activate virtual environment
TypeScript
1 vote186 views1 answer
Typescript space between capital letters
TypeScript
15 votes201 views4 answers
Typescript clear array
TypeScript
4 votes207 views3 answers
Find distance between two points in opencv python
TypeScript
0 vote217 views2 answers
Preventing letters from being placed in an input ts
TypeScript
5 votes220 views2 answers
Lofi hip hop beats cool
TypeScript
3 votes225 views1 answer
Typescript add global variable to window
TypeScript
9 votes237 views2 answers
Open and append to file python if exists if not create
TypeScript