/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 vote235 views1 answer
Multiple widgets as single widget flutter row for
TypeScript
2 votes161 views2 answers
Typescript iterate over enum
TypeScript
1 vote193 views6 answers
Decode jwt
TypeScript
5 votes158 views2 answers
How to select array element via id and print it
TypeScript
0 vote149 views1 answer
How to select a column with brackets in jupyter notebook
TypeScript
0 vote166 views1 answer
Ignore hosts option in network proxy in ubuntu 16.04
TypeScript
20 votes159 views2 answers
Typescript how to color your console loggers
TypeScript
0 vote156 views1 answer
How to print list contents in java
TypeScript
2 votes155 views2 answers
Singleton design pattern typescript
TypeScript
1 vote164 views2 answers
Typescript formik useFormik
TypeScript