ExcelDBA
Labels
Excel
(2)
Others
(3)
SQL
(4)
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
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment