在Google Sheet应用程序脚本中查找价值

function findValue(value) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  
  for (var i = 0; i < values.length; i++) {
    for (var j = 0; j < values[i].length; j++) {
      if (values[i][j] == value) {
        var row = i + 1;
        var column = String.fromCharCode(65 + j);
        var cell = column + row;
        return "找到了价值 " + value + " 在单元格 " + cell;
      }
    }
  }
  
  return "未找到价值 " + value;
}