Answers for "app script get last row using e"

Whatever

0

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);

Posted by: Guest on December-13-2020

Code answers related to "app script get last row using e"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#