javascript - 如何检查 Google 表格数组中单元格中的值？

Question

我想计算定义的数组/范围中出现了多少个 Y 和 N:

单元格范围:D4:D42

function myFunction() {
 var count = SpreadsheetApp.getActiveSheet().getRange(5, 3, 40, 1);
 var numRows = count.getNumRows();
 var numCols = count.getNumColumns();
 var y = 0;
 var n = 0;

 for (var i = 1; i <= numRows; i++) {
  for (var j = 1; j <= numCols; j++) {
   var currentValue = count.getCell(i, j).getValue();
   if (currentValue = "y") {
    y = y + 1;
   } else if (currentValue = "n") {
    n = n + 1;
   }
  }
 }
 Browser.msgBox("There are " + y + " paid & " + n + " not paid");
}

这将返回 40 个 Y 和 0 个 N

不确定我在这里做错了什么，但我认为这是一个简单的修复!

Answer 1

问题出在这一行:

if (currentValue = "y") {

您正在将“y”分配给 currentValue。要实际检查相等性，您应该尝试“===”运算符。尝试一下，看看是否能解决您的问题:

function myFunction() {
    var count = SpreadsheetApp.getActiveSheet().getRange(5, 4, 39, 1);
    var numRows = count.getNumRows();
    var numCols = count.getNumColumns();
    var y = 0;
    var n = 0;

    for (var i = 1; i <= numRows; i++) {
        for (var j = 1; j <= numCols; j++) {
            var currentValue = count.getCell(i, j).getValue();
            if (currentValue === "y") {
                y = y + 1;
            } else if (currentValue === "n") {
                n = n + 1;
            }
        }
    }
    Browser.msgBox("There are " + y + " paid & " + n + " not paid");
}

我还更新了 getRange() 参数以匹配 D4:D42。在您的代码中，它们匹配 C5:C44。请参阅getRange() function documentation .