/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 vote205 views1 answer
Set array of objects in localstorage
TypeScript
2 votes190 views1 answer
Get all the game objects in a scene unity
TypeScript
3 votes156 views1 answer
Typescript loop through string
TypeScript
0 vote241 views1 answer
Can you make twitter bots in node.js
TypeScript
0 vote199 views1 answer
Dart check if variable is list
TypeScript
0 vote200 views1 answer
Typescript date set time end of day
TypeScript
1 vote203 views1 answer
Unity lists number of
TypeScript
0 vote331 views1 answer
The create-react-app imports restriction outside of src directory
TypeScript
0 vote236 views1 answer
Les différents types de cours
TypeScript
1 vote250 views1 answer
Shortcuts for ajax in vscode
TypeScript