Answers for "get last row google scripts"

google script last row

var cells = sheetInput.getRange("a:a").getValues();//Gets all cells in col A.
   
    var filter = cells.filter((cell) => cell != "");//filters out the blanks.
    var lr = parseInt(filter.length) + 1;//This is the Last Row.
    
    Logger.log(lr);

apps script get last row with data

var cur_ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = cur_ss.getDataRange().getValues();
  
  var Avals = cur_ss.getRange("B9:B").getValues();
  var Alast = Avals.filter(String).length;
  return (Alast + 9);

get last row google scripts

//To get last row of the sheet.
var LastRowOfSheet = SpreadsheetApp.getActive().getActiveSheet().getRange('a:a').getLastRow();

//To get last row with value in it.
var LastRow_WithValue = SpreadsheetApp.getActive().getActiveSheet().getLastRow();

.setRowHeights google script

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

// Sets the first three rows to a height of 20 pixels
sheet.setRowHeights(1, 3, 20);