/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 vote155 views1 answer
Add correct host key in /root/.ssh/known_hosts to get rid of this message
TypeScript
9 votes183 views3 answers
Fragments in react
TypeScript
1 vote187 views1 answer
Whats ruby used for
TypeScript
0 vote147 views1 answer
How to get the table contents from a file in python
TypeScript
0 vote153 views1 answer
Call appply bind
TypeScript
33 votes205 views4 answers
Typescript remove element from array
TypeScript
0 vote174 views1 answer
Response 404 requests python compare
TypeScript
0 vote165 views1 answer
Why touchable opacity to take width of its child
TypeScript
0 vote170 views1 answer
Regexp in typescript types
TypeScript
0 vote164 views1 answer
How to add array of objects in swagger 2.0
TypeScript