javascript - 无法调用未定义的方法 "getValues"

Question

返回的错误是:

"TypeError: Cannot call method "getValues" of undefined. (line 7, file "Code")"

function setDropdown() {
  var ss = SpreadsheetApp.getActive();
  var sht = ss.getSheetByName('Sheet1');

  selecionaRange(sht);

  var arrayValues = rng.getValues();

  var rangeRule = SpreadsheetApp.newDataValidation().requireValueInList(arrayValues);
  ss.getRange('sheet1!A6').setDataValidation(rangeRule);
}

function selecionaRange(sht) {
  if (sht.getRange("A1") == "IM") {
    return rng = sht.getRange('B1:B5');
  }
}

Answer 1

非常感谢你试图帮助我。我发现我的问题是在 sht.getRange("A1") 之后缺少 .getValue() 方法

现在可以了。

var rng = null //or better another value
  function setDropdown() {
   var ss = SpreadsheetApp.getActive();
   var sht = ss.getSheetByName('Sheet1');

 selecionaRange(sht);

 var arrayValues = rng.getValues();

 var rangeRule = SpreadsheetApp.newDataValidation().requireValueInList(arrayValues);
 ss.getRange('sheet1!A6').setDataValidation(rangeRule);
}

function selecionaRange(sht) {
  if (sht.getRange("A1").getValue() == "IM") { //Here must have .getValue()
  return rng = sht.getRange('B1:B5');
  }
}