/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 vote338 views1 answer
Typoescript find multiple items in array and return found
TypeScript
1 vote338 views1 answer
Two plots side by side r
TypeScript
0 vote336 views1 answer
How to take inputs in one line in c
TypeScript
0 vote371 views1 answer
Angular calculate difference between two dates
TypeScript
0 vote312 views1 answer
Are flights still running
TypeScript
5 votes309 views4 answers
Element implicitly has an 'any' type because expression of type 'string' can't be used to index type
TypeScript
0 vote316 views1 answer
Spread types may only be created from object types firebase
TypeScript
1 vote327 views2 answers
Subplots in seaborn python
TypeScript
4 votes374 views10 answers
Roblox
TypeScript
1 vote281 views1 answer
Use of value_counts in python
TypeScript