/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 votes271 views2 answers
Represent array items angular
TypeScript
0 vote287 views1 answer
How to call a export constants in nodejs
TypeScript
0 vote297 views1 answer
Typescript how to check if string is a date
TypeScript
1 vote288 views1 answer
Ion slides updateAutoHeight
TypeScript
5 votes274 views2 answers
Type usestate typescript
TypeScript
63 votes507 views6 answers
React router install
TypeScript
2 votes292 views1 answer
How to get post of instragram using api
TypeScript
1 vote250 views1 answer
Typing in typescript
TypeScript
0 vote292 views1 answer
1.Load the data set cats from the library MASS
TypeScript
0 vote277 views2 answers
Handlebars custom helper
TypeScript