/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

1 vote108 views1 answer
Remove duplicates from array angular
TypeScript
0 vote132 views1 answer
Ts pipe function
TypeScript
6 votes76 views2 answers
After effects download
TypeScript
2 votes116 views2 answers
GetServersideprops in nextjs
TypeScript
0 vote110 views1 answer
Check if all array elements match closure swift
TypeScript
14 votes115 views3 answers
Property '...' has no initializer and is not definitely assigned in the constructor
TypeScript
2 votes113 views1 answer
Typescript get the mime type from base64 string
TypeScript
0 vote120 views1 answer
Regex exec returns null
TypeScript
0 vote131 views2 answers
Promise allsettled typescript
TypeScript
0 vote170 views1 answer
Are multiple statements per line in python discouraged PEP 257
TypeScript