getrange google sheets 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: getRange
let SHEET = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
let values = SHEET.getRange(2, 1, SHEET.getLastRow()-1, 1).getValues();
// .getRange(row, column, numRows, numColumns)
// So '.getLastRow()-1' because 'values' starts at the second row
let valuesDestination = SHEET.getRange(`B2:B${SHEET.getLastRow()}`)
valuesDestination.setValues(values);