基于单个单元格和数组删除行的Google Sheet脚本

function deleteRowBasedOnCell() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var cellValue = sheet.getRange("A1").getValue(); // 获取单元格A1的值

  if (cellValue === "要删除的条件") {
    sheet.deleteRow(1); // 删除第1行
  }
}

function deleteRowBasedOnArray() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues(); // 获取整个表格的数据

  for (var i = data.length - 1; i >= 0; i--) {
    var row = data[i];
    if (row[0] === "要删除的条件") {
      sheet.deleteRow(i + 1); // 删除第i+1行
    }
  }
}