问如何使用1个输入获取同一行单元格的值？

EN

function myFunction( value1 )
{
  var cell1 = SpreadsheetApp.getActiveSheet().getRange(value1);

// myFunction("A1") is the same as following:
//cell1 = SpreadsheetApp.getActiveSheet().getRange("A1");

// Define the value here, if it is fixed. 
//Otherwise in the function parameters
var columnCount = 6;

// Define the range to get the values from. Parameters: 
// Starting row of the range : row of Cell1
// Starting column of the range : column of cell1 
// Number of rows = 1 
// And the number of columns we wanted
var values = SpreadsheetApp.getActiveSheet()
                         .getRange( cell1.getRow() , cell1.getColumn() , 1 , columnCount)
                         .getValues();

//  var values == [[ value, value, value, value, value, value ]]
//  so actually values[0] is what you requested, the values from A1 to F1

// Now if you want to, for example sum up the values
// You just iterate through the values[0]

var sum = Number(0);
for ( var i = 0; i < values[0].length; i++ )
{
 var cellValue = values[0][i]; 

 sum += Number(cellValue);
}

return sum; 
}

function getValueRow (value1) {
  var sh = SpreadsheetApp.getActive().getSheets()[1];
  // Get each cell value in column "A" and flatten for indexOf() use
  var bound_col = sh.getRange(1, 1, sh.getLastRow()).getValues().join().split(",");
  // Compare value1 to column "A" data to find its row
  // `indexOf()` returns the index of the first match
  var argument_row = bound_col.indexOf(value1);

  if (argument_row != -1) { 
    // Get the row data of value1 from column "A" to column "F"
    var row_data = sh.getRange((argument_row + 1), 1, 1, 6).getValues();

    Logger.log("%s is in row %s", value1, (argument_row + 1));
    Logger.log("The row_data is: %s", row_data);

  } else {
    Logger.log("Can not find %s in column A", value1);
  }
}