/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 vote209 views1 answer
Tailwind base components utilities
TypeScript
0 vote207 views1 answer
This typescript
TypeScript
0 vote196 views1 answer
Adoni migrate
TypeScript
0 vote250 views1 answer
Sourcetree winmerge arguments three way merge
TypeScript
0 vote203 views1 answer
How to add enchantments to mobs plugin
TypeScript
0 vote208 views1 answer
This expression is not callable. typescript angular 11 socket.io
TypeScript
8 votes214 views1 answer
React init ts
TypeScript
1 vote242 views1 answer
Adonis query delete
TypeScript
0 vote192 views1 answer
Get enum key typescript
TypeScript
6 votes184 views3 answers
React-native use typescript
TypeScript