/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 vote237 views1 answer
Where do you store your test data
TypeScript
0 vote240 views1 answer
Subscripts list c#
TypeScript
0 vote225 views1 answer
FIFA 21 esports temas
TypeScript
1 vote208 views1 answer
React routes not working after build
TypeScript
2 votes242 views1 answer
Adonis model preload with condition
TypeScript
18 votes226 views3 answers
Typescript sort array of objects
TypeScript
0 vote173 views2 answers
Elixir list append
TypeScript
0 vote294 views2 answers
React native elements input phone number max characters
TypeScript
0 vote226 views1 answer
Can i use different flutter versions for differnt progjects ?
TypeScript
4 votes224 views1 answer
Typescript string interpolation
TypeScript