importrange google sheets code example

Example 1: google sheets combine ranges

-- Google Sheets: Combine ranges
={sheet1!a:a; sheet2!a:a}

Example 2: getranges google script

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

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