在Google Apps脚本中删除与namedRange关联的行

var namedRange = SpreadsheetApp.getActiveSpreadsheet().getRangeByName("myRange");

var range = namedRange.getRange();
var startRow = range.getRow();
var endRow = range.getLastRow();

var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
sheet.deleteRows(startRow, endRow - startRow + 1);

function deleteRowsAssociatedWithNamedRange() {
  var namedRange = SpreadsheetApp.getActiveSpreadsheet().getRangeByName("myRange");
  var range = namedRange.getRange();
  var startRow = range.getRow();
  var endRow = range.getLastRow();
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.deleteRows(startRow, endRow - startRow + 1);
}