get range all values google script code example

Example 1: getranges google script

let SS = APP.getActiveSpreadsheet();
let sheetIndex0 = SS.getSheets()[0];

sheetIndex0.getRangeList(['A1', 'B1:C7']).setHorizontalAlignment("center");

Example 2: google script range get cell values

var myCell = myRange.getCell(row, column)	//Returns a given cell within a range.