google script google sheets get range code example
Example 1: google apps script to get spreadsheet range to a variable
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
var range = sheet.getRange('A1:D10');
var values = range.getValues();
var selection = sheet.getSelection();
var currentCell = selection.getCurrentCell();
var activeRange = selection.getActiveRange();
Example 2: getranges google script
let SS = APP.getActiveSpreadsheet();
let sheetIndex0 = SS.getSheets()[0];
sheetIndex0.getRangeList(['A1', 'B1:C7']).setHorizontalAlignment("center");