Google Apps脚本 - 根据单元格值查找行号 [英] Google Apps Script - Find Row number based on a cell value

问题描述

电子表格在多行和多行中包含大量数据

我们正在寻找一些帮助以找到包含特定值的单元格的行号。列。我遍历.getDataRange，并可以找到包含我正在查找的值的单元格。一旦找到，我想知道他的单元格所在的行，以便我可以进一步获取更多的单元格值，因为我确切知道附加信息的下行和/或多少行来自找到的单元格。

以下是用于查找包含特定字符串的单元格的代码。

 函数findCell（）{
 var ss = SpreadsheetApp.getActiveSpreadsheet（）; 
 var sheet = ss.getActiveSheet（）; 
 var dataRange = sheet.getDataRange（）; 
 var values = dataRange.getValues（）; 
 
 for（var i = 0; i< values.length; i ++）{
 var row =; 
 for（var j = 0; j< values [i] .length; j ++）{
 if（values [i] [j] ==User）{
 row =值[i] [j + 1]; 
 Logger.log（row）; 
} 
} 
} 
} 
  

输出 Logger.log（row）它给我我想要的值。我想确定每个值都在哪个行，所以我可以沿着X行和X列取得其他单元格的内容。

解决方案

我对谷歌应用程序了解不多，但在这种情况下，它看起来像 [i] 是您的行号。

所以如果你做了这样的事情：

  function findCell（）{
 var ss = SpreadsheetApp.getActiveSpreadsheet（）; 
 var sheet = ss.getActiveSheet（）; 
 var dataRange = sheet.getDataRange（）; 
 var values = dataRange.getValues（）; 
 
 for（var i = 0; i< values.length; i ++）{
 var row =; 
 for（var j = 0; j< values [i] .length; j ++）{
 if（values [i] [j] ==User）{
 row =值[i] [j + 1]; 
 Logger.log（row）; 
 Logger.log（i）; //这是你的行号
 
 
 
 
 code $ pre 
I'm looking for some assistance on find the row number for a cell that contains a specific value.

The spreadsheet has lots of data across multiple rows & columns.  I'm looping over the .getDataRange and can located the cell containing the value I'm looking for.  Once found I'd like to know the row that his cell is in, so that I can further grab additional cell values since I know exactly how many rows down and/or columns over the additional information is from the found cell.

Here is a bit of the code for finding the cell containing a specific string.
function findCell() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var dataRange = sheet.getDataRange();
  var values = dataRange.getValues();

  for (var i = 0; i < values.length; i++) {
    var row = "";
    for (var j = 0; j < values[i].length; j++) {     
      if (values[i][j] == "User") {
        row = values[i][j+1];
        Logger.log(row);
      }
    }    
  }  
}
When outputting Logger.log(row) it gives me the values I'm looking for.  I want to determine what row each value is in, so I can then go down X number of rows and over X columns to get the contents of other cells.
解决方案
I don't know much about google apps but it looks like [i] is your row number in this circumstance. 

So if you did something like:
function findCell() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var dataRange = sheet.getDataRange();
  var values = dataRange.getValues();

  for (var i = 0; i < values.length; i++) {
    var row = "";
    for (var j = 0; j < values[i].length; j++) {     
      if (values[i][j] == "User") {
        row = values[i][j+1];
        Logger.log(row);
        Logger.log(i); // This is your row number
      }
    }    
  }  
}


                        
这篇关于Google Apps脚本 - 根据单元格值查找行号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！