Recherche ensemble de la feuille de calcul pour trouver du texte dans une cellule dans une feuille de calcul Google, puis imprimer l'ensemble de la ligne

et voici un script solution " vous pourriez essayer. Il existe de nombreuses approches possibles, c'est l'un d'entre eux...

function testfindRow(){ ;//this function only to test the other one by giving it a parameter and using its result.
        var ss = SpreadsheetApp.getActiveSpreadsheet();
        var otherSheet=ss.getSheets()[1];//assuming there is a second sheet to copy to
        var datatocopy=findRow('Hello');
        Logger.log(datatocopy)
        if (datatocopy!=-1){
        otherSheet.getRange(otherSheet.getLastRow()+1,1,1,datatocopy[0].length).setValues(datatocopy);
        }
 }
//
function findRow(item) { ;//the actual search function
        var ss = SpreadsheetApp.getActiveSpreadsheet();
        var sheet=ss.getSheets()[0];
        var values = sheet.getDataRange().getValues();
          for(cc =0; cc < values.length; ++cc) {
            if(values[cc].toString().match(item)==item){break};//here you can eventually use string modifiers like toLowerCase() to allow for wider search criteria
             }
        Logger.log(cc);//the array index in which the result was found, cc+1 is the Row index
        if (cc==values.length){return -1}
         var resultArray=sheet.getRange(cc+1,1,1,values[cc].length).getValues()
         return resultArray ;//the returned value is a 2 dimensions array to use with setValues()
 }

À la suite de votre commentaire, voici une version qui renvoie toutes les Lignes qui contiennent l'article, j'ai dû changer de recouvrement d'erreur, mais l'ensemble des choses est assez simple, après tout.

    function testfindRow(){ ;//this function only to test the other one by giving it a parameter and using its result.
            var ss = SpreadsheetApp.getActiveSpreadsheet();
            var otherSheet=ss.getSheets()[1];//assuming there is a second sheet to copy to
            var datatocopy=findRow('Hello');
            if (datatocopy.length>0){
            otherSheet.getRange(otherSheet.getLastRow()+1,1,datatocopy.length,datatocopy[0].length).setValues(datatocopy);
            }
     }
    //
    function findRow(item) { ;//the actual search function
            var ss = SpreadsheetApp.getActiveSpreadsheet();
            var sheet=ss.getSheets()[0];
            var resultArray=new Array();
            var values = sheet.getDataRange().getValues();
              for(cc =0; cc < values.length; ++cc) {
                if(values[cc].toString().match(item)==item){//here you can eventually use string modifiers like toLowerCase() to allow for wider search criteria
//or like this to search only in column D //if(values[cc][3].toString().match(item)==item){
                resultArray.push(values[cc]);
                            };
                 }
            Logger.log(resultArray);//the array of Rows in which the item was found, 
            return resultArray ;//the returned value is a 2 dimensions array to use with setValues()
     }

OriginalL'auteur Serge insas