Labels

Sunday, September 16, 2018

GDrive - Delete All records in Active Sheet

function DeleteDataInActiveSheet() {

    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var start, end;

    start = 1;
    end = sheet.getLastRow();

    sheet.deleteRows(start, end)

}

No comments:

Post a Comment