/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

11 votes147 views5 answers
Shortcode_atts wordpress
TypeScript
1 vote142 views1 answer
A function that prints all numbers from 0 - n Added together python
TypeScript
0 vote152 views1 answer
Five elements in the finger
TypeScript
-1 vote130 views1 answer
Div resize event typescript
TypeScript
0 vote143 views1 answer
Typescript check if value is in enum
TypeScript
2 votes131 views1 answer
How to send information from javascript to flask route
TypeScript
4 votes134 views1 answer
Property 'value' does not exist on type 'HTMLElement'.
TypeScript
0 vote233 views1 answer
Typescript import variable from another file
TypeScript
3 votes159 views1 answer
Google chrome extensions content scripts matches
TypeScript
0 vote133 views1 answer
Typescript sort number array descending
TypeScript