Google Apps 脚本：查找列中的元素并返回相应的行

Question

所以我希望我的程序在我的谷歌表格的第一列中搜索一个元素，如果找到该元素，则返回相应的行。当我测试此代码时，即使该元素存在，也显示它不存在。function doGet(e){  var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1AssaPoFPcazneN44EjE04fE99MxTaPZg5uMsO1Klh4o/edit#gid=0");  var sheet = ss.getSheetByName("Sheet1");  return finds(e,sheet);}function doPost(e){  var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1AssaPoFPcazneN44EjE04fE99MxTaPZg5uMsO1Klh4o/edit#gid=0");  var sheet = ss.getSheetByName("Sheet1");  return finds(e,sheet);  }function finds(e,sheet) {  var records = {};  var scannedData = e.parameter.sdata;  var range = sheet.getDataRange().getDisplayValues().map(r => r[0]); // -> get display Data as 1D array - Col A  var  data = [];  if(range.includes(scannedData)) { // use includes to see if scannedData is included in the array       var row_scannedData = range.indexOf(scannedData);       var result =  sheet.getRange(row_scannedData,1,1,4);  //fetches the entire row belonging to the result       data.push(result);  //pushes the row in an array       records.items = data;        var finalresult = JSON.stringify(records);       return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON);  }  return ContentService.createTextOutput("Not Found").setMimeType(ContentService.MimeType.TEXT);} 

Answer 1

回答：

您可以使用TextFinder.

代码示例：

假设 A 列中只有一个单元格包含您的搜索词：

function searchColumnA(searchTerm) {

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];

  var aColumn = sheet.getRange("A1:A" + sheeet.getLastRow());

  var tf = aColumn.createTextFinder(searchTerm).findAll(); 

  return tf[0].getRow();

}