Google Apps脚本hideRow()停止for循环

function hideRowsOptimized() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getRange('A1:A100'); // 假设你要隐藏前100行中的某些行
  var values = range.getValues();
  
  for (var i = 0; i < values.length; i++) {
    if (shouldHideRow(values[i])) { // 自定义函数判断是否需要隐藏该行
      sheet.hideRows(i + 1); // 注意行号从1开始
    }
  }
}

function shouldHideRow(rowData) {
  // 根据行数据判断是否需要隐藏该行
  return rowData[0] === '隐藏'; // 示例条件
}

function hideRowsWithBreak() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastRow = sheet.getLastRow();
  var batchSize = 10;
  
  for (var startRow = 1; startRow <= lastRow; startRow += batchSize) {
    var endRow = Math.min(startRow + batchSize - 1, lastRow);
    var range = sheet.getRange(startRow, 1, endRow - startRow + 1, sheet.getLastColumn());
    
    for (var i = startRow; i <= endRow; i++) {
      if (shouldHideRow(sheet.getRange(i, 1).getValue())) {
        sheet.hideRows(i);
      }
    }
    
    Utilities.sleep(1000); // 暂停1秒
  }
}

function hideRowsWithErrorHandling() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastRow = sheet.getLastRow();
  
  for (var i = 1; i <= lastRow; i++) {
    try {
      if (shouldHideRow(sheet.getRange(i, 1).getValue())) {
        sheet.hideRows(i);
      }
    } catch (e) {
      Logger.log('Error at row ' + i + ': ' + e.message);
    }
  }
}