/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 vote161 views1 answer
How to concate a string to all elements in a list in python
TypeScript
2 votes154 views3 answers
Boolean to string typescript
TypeScript
0 vote153 views1 answer
Display entry count for specific column using value_counts spyder.
TypeScript
0 vote146 views1 answer
Representation of graph usig sets and hash in python
TypeScript
0 vote149 views1 answer
Typescript generic dictionary
TypeScript
1 vote163 views1 answer
Add 'CUSTOM_ELEMENTS_SCHEMA' to the '@NgModule.schemas' of this component to suppress this message
TypeScript
0 vote163 views1 answer
Flutter rotate animation icon on press
TypeScript
-1 vote140 views3 answers
Speed test
TypeScript
0 vote140 views1 answer
Formatting to six digits in python
TypeScript
0 vote156 views1 answer
Real time charts in flutter
TypeScript