从末尾的行中删除google Spreadsheet中的重复行 [英] Removing Duplicate Rows in a google Spreadsheet from the end row

问题描述

我在Google spraedsheet中找到了以下用于删除重复行的代码:从这个网址: https://developers.google.com/apps-script/articles/removing_duplicates

i find this code for remove duplicate row in google spraedsheet: from this url: https://developers.google.com/apps-script/articles/removing_duplicates

function removeDuplicates() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  var data = sheet.getDataRange().getValues();
  var last=sheet.getLastRow();
  var newData = new Array();
  for(i in data){
    //Logger.log(i);
    var row = data[i];
    //Logger.log(row[5]);
    var duplicate = false;
    for(j in newData){
      //Logger.log(newData[j][5]);
      if(row[5] == newData[j][5]){
        duplicate = true;
      }
    }
    if(!duplicate){
      newData.push(row);
    }
  }
  sheet.clearContents();
  sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData);
}

但是此功能开始从第一行中删除重复的行，我想开始从工作表的末行中删除.我该怎么办?

but this function start removing duplicate row from the first row, i want to start removing from the end row of sheet. How can i do this?

推荐答案

尝试使用JavaScript数组 reverse()方法.它在下面两次使用:

Try the JavaScript array reverse() method. It is used twice below:

function removeDuplicates() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  var data = sheet.getDataRange().getValues();

  data.reverse(); //reverses the row order.

  var last=sheet.getLastRow();
  var newData = new Array();
  for(i in data){
    //Logger.log(i);
    var row = data[i];
    //Logger.log(row[5]);
    var duplicate = false;
    for(j in newData){
      //Logger.log(newData[j][5]);
      if(row[5] == newData[j][5]){
        duplicate = true;
      }
    }
    if(!duplicate){
      newData.push(row);
    }
  }

  newData.reverse(); // reverses your data back to its original order.

  sheet.clearContents();
  sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData);
}

请让我知道是否可行.

这篇关于从末尾的行中删除google Spreadsheet中的重复行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！