/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 vote188 views1 answer
Check if package exists inside the device adb
TypeScript
1 vote185 views1 answer
What is endurance testing
TypeScript
0 vote184 views1 answer
Separate subplots in python
TypeScript
2 votes180 views1 answer
Key value pairs typescript
TypeScript
0 vote152 views1 answer
Create file object from url typescript
TypeScript
0 vote223 views1 answer
How can I create an array with a range of decimal increments in SwiftUI ?
TypeScript
2 votes197 views1 answer
Typescript sum all array values
TypeScript
1 vote182 views1 answer
React protected routes typescript
TypeScript
0 vote201 views1 answer
How to disable piecelabel on certian charts and keep on other chartjs
TypeScript
0 vote191 views1 answer
'this' context of type 'void' is not assignable to method's 'this' of type 'Observable<{}>'.
TypeScript