如何在Google Script中更新重复行

function updateDuplicateRows() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getRange('A:C');
  var values = range.getValues();
  var uniqueRows = [];
  
  for (var i = 0; i < values.length; i++) {
    var isDuplicate = false;
    
    for (var j = 0; j < uniqueRows.length; j++) {
      if (values[i].join() === uniqueRows[j].join()) {
        isDuplicate = true;
        // 更新重复行的值
        sheet.getRange(i + 1, 1, 1, values[i].length).setValue('New Value');
        break;
      }
    }
    
    if (!isDuplicate) {
      uniqueRows.push(values[i]);
    }
  }
  
  range.clearContent();
  var newRange = sheet.getRange(1, 1, uniqueRows.length, uniqueRows[0].length);
  newRange.setValues(uniqueRows);
}