Google Sheets脚本查找具有值的单元格

function findCellsWithValue(value) {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();
  var foundCells = [];

  for (var row = 0; row < values.length; row++) {
    for (var col = 0; col < values[row].length; col++) {
      if (values[row][col] === value) {
        var cell = sheet.getRange(row + 1, col + 1);
        foundCells.push(cell.getA1Notation());
      }
    }
  }

  return foundCells;
}