/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

1 vote140 views1 answer
Tostring kotlin
TypeScript
4 votes133 views2 answers
How to add a new propety into all documents in mongodb
TypeScript
2 votes149 views2 answers
How to check constraints on a table in sql oracle
TypeScript
0 vote143 views1 answer
Could not find method Properties() for arguments [] on project ':app'
TypeScript
1 vote168 views1 answer
List open ports firewalld
TypeScript
1 vote141 views1 answer
Why does mongoose minimize by default
TypeScript
1 vote143 views2 answers
The server time zone value 'FLE' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more
TypeScript
7 votes164 views2 answers
Replaceall typescript
TypeScript
0 vote131 views1 answer
Wordpress posts sidebar with category link programmatically
TypeScript
1 vote211 views1 answer
'Missing locale data for the locale "pt-BR".' for pipe 'DatePipe'
TypeScript