Split range into an array of ranges representing the rows of the original range #google-apps-script #range

splitRangeIntoRows.gs

function splitRangeIntoRows(range) {
  const sheet = range.getSheet();
  const firstRow = range.getRow();
  const lastRow = firstRow + range.getNumRows() - 1;
  let rows = [];
  for (let rowIndex = firstRow; rowIndex <= lastRow; rowIndex++) {
    rows.push(sheet.getRange(`${rowIndex}:${rowIndex}`));
  }
  return rows;
}