/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 vote342 views1 answer
Typescript arr numbers and strings
TypeScript
0 vote330 views1 answer
Q5: Identify the five major components of a communications system.
TypeScript
1 vote307 views1 answer
Add correct host key in known_hosts to get rid of this message
TypeScript
0 vote329 views1 answer
React onclick action starts automatically
TypeScript
0 vote388 views1 answer
Supertest typescript
TypeScript
6 votes333 views1 answer
React native typescrypt
TypeScript
0 vote365 views1 answer
How many sets of 3 in 4
TypeScript
0 vote337 views2 answers
How to compare two entity objects in c# to update
TypeScript
4 votes384 views10 answers
Roblox
TypeScript
0 vote307 views1 answer
Write in file in typescript
TypeScript