Breaking News: Grepper is joining You.com. Read the official announcement!

script editor google sheets create new sheet

Sulphix answered on September 17, 2021 Popularity 9/10 Helpfulness 2/10

answer script editor google sheets create new sheet

script editor google sheets create new sheet

Comment

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");
}

Popularity 9/10 Helpfulness 2/10 Language typescript

Source: stackoverflow.com

Tags: editor google-sheets script typescript

Link to this answer
Share Copy Link