Reputation: 1
Tried with the mentioned script but not working.
var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet1');
sheet.getLastRow().clearContent()
Upvotes: 0
Views: 482
Reputation: 14537
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
var last_row = sheet.getLastRow();
var last_column = sheet.getLastColumn();
sheet.getRange(last_row, 1, 1, last_column).clearContent();
Upvotes: 2