/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 vote28 views1 answer
Union of two sets python syntax
TypeScript
1 vote30 views1 answer
Pathmatch angular
TypeScript
0 vote31 views1 answer
Ignore hosts option in network proxy in ubuntu 16.04
TypeScript
0 vote34 views1 answer
Please fill in the missing parts of the code to print "I love C++" on the screen.
TypeScript
0 vote31 views2 answers
Can subclass method infere exceptions of its superclass method
TypeScript
4 votes26 views2 answers
Setup express with typescript
TypeScript
0 vote66 views1 answer
Common mistakes in testing
TypeScript
0 vote28 views1 answer
Connect onboarding for custom accounts specify country
TypeScript
34 votes30 views3 answers
Powershell enable scripts
TypeScript
1 vote28 views3 answers
Typescript check undefined
TypeScript