[gas][sheetsapi] 選択中の行を指定した行の下に移動

moveRowsByActiveRow.gs.js

function onOpen() {
  var ui = SpreadsheetApp.getUi();

  ui.createMenu("❖ マクロ")
    .addItem("[選択行] 指定行の下に行移動", "moveRowsByActiveRow")
    .addToUi()
  ;
}

function moveRowsByActiveRow() {
  var spreadsheet      = SpreadsheetApp.getActiveSpreadsheet();
  var activeSheet      = spreadsheet.getActiveSheet();
  var currentSheetName = activeSheet.getSheetName();
  var activeRangeList  = SpreadsheetApp.getActiveRangeList().getRanges();
  var targetRowIndex   = +(Browser.inputBox("移動先の行番号を入力してください"));
  var requestList      = [];
  var gap              = 0;

  if (!targetRowIndex) {
    Browser.msgBox("Error: エラーが発生しました");
    return;
  }

  activeRangeList.forEach(function (range, index) {
    var startRowIndex = range.getRowIndex();
    var lastRowIndex  = range.getLastRow();

    requestList.push({
      "moveDimension": {
        "source": {
          "sheetId": activeSheet.getSheetId(),
          "dimension": "ROWS",
          "startIndex": startRowIndex - 1,
          "endIndex": lastRowIndex
        },
        "destinationIndex": targetRowIndex + gap
      }
    });

    gap += (lastRowIndex - startRowIndex + 1);
  });

  var req = {
    "requests": requestList
  };

  Sheets.Spreadsheets.batchUpdate(JSON.stringify(req), spreadsheet.getId());
}