向后循环:

  for (var i = (values.length-1); i > 0; i--) {
         if (values[i][0] == productCode) {
        data.push([values[i][22],values[i][23],values[i][24],values[i][25]]); //This array is for a certain purpose.
        headerData.push(headerValues[i]);//This array is for another certain purpose.
        sheet.deleteRow(i+1); //This is the one I'm having trouble with.    
    } 
  }