Joy
Joy

Reputation: 1

How to clear last row content of google sheet by using of apps scrpt?

Tried with the mentioned script but not working.

var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet1');
sheet.getLastRow().clearContent()

Upvotes: 0

Views: 482

Answers (1)

Yuri Khristich
Yuri Khristich

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

Related Questions