/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 vote190 views1 answer
Communication between components in angular
TypeScript
0 vote178 views2 answers
Iframe redirects to another page
TypeScript
-1 vote223 views1 answer
What is http request made of
TypeScript
0 vote180 views1 answer
How to compile ts in cmd
TypeScript
0 vote168 views1 answer
Font awesome reeact js example
TypeScript
0 vote175 views2 answers
Snippets iamge by cod
TypeScript
0 vote192 views1 answer
How to check if a string is composed only of alphabets in python
TypeScript
2 votes186 views2 answers
GetServersideprops in nextjs
TypeScript
0 vote165 views1 answer
Loading assets in ionic react
TypeScript
0 vote195 views1 answer
Ts in r
TypeScript