/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 vote335 views1 answer
Python program to find sum of digits of a number using while loop
TypeScript
0 vote305 views2 answers
Image in container flutter
TypeScript
0 vote283 views1 answer
Mat-checkbox change
TypeScript
0 vote351 views1 answer
How test with limited information
TypeScript
0 vote324 views2 answers
Python check if dir exists else create
TypeScript
1 vote282 views1 answer
How to delete the spec.ts file in project all togethre
TypeScript
0 vote304 views3 answers
Check table exists in db laravel
TypeScript
0 vote322 views1 answer
Listen to hub events asw analytics
TypeScript
1 vote315 views2 answers
Property 'style' does not exist on type 'Element'
TypeScript
0 vote307 views1 answer
Why touchable opacity to take width of its child
TypeScript