google sheets get range value code example
Example 1: google script range get cell values
var myCell = myRange.getCell(row, column) //Returns a given cell within a range.
Example 2: google sheets get ranges
//getRange(row, column, optNumRows, optNumColumns);
Sheet.getRange(1,1,1,12);
//row --- int --- top row of the range
//column --- int--- leftmost column of the range
//optNumRows --- int --- number of rows in the range.
//optNumColumns --- int --- number of columns in the range