javascript - Cell.getValue 没有正确比较值
问题描述
我是谷歌应用程序脚本的新手,我遇到了问题。当我尝试将单元格值与两个整数进行比较时,它每次都有效。在我的电子表格中,只有少数几个值符合这些约束条件。这是我的代码:
function CHECK_CORRELATION() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var rangeData = sheet.getDataRange();
var lastColumn = rangeData.getLastColumn();
var lastRow = rangeData.getNumRows();
var counter = 0;
var counter2 = 0;
var values = rangeData.getValues()
for (var j = 2; j <= lastRow; j++){
var cell = sheet.getRange(j, 8)
if (cell.isBlank()) {
continue;
} else {
if (0.9<=cell.getValue()<=1.1){
Logger.log(cell.getValue());
counter++;
}
counter2++;
}
}
Logger.log(counter)
Logger.log(counter2)
if (counter>(counter2/2)) {
return "The idea that a student will have motivation and has a part time job co-occur"
} else {
return "The idea that a student will have motivation and has a part time job does not co-occur"
}
}
它显示 counter 是 62而counter2 是 62,即使它不应该是。
任何帮助将不胜感激!
解决方案
你已经很棒了!我刚刚清理了你的 for 循环。我假设您的数据在第 8 列,对吧?
让我知道这是否解决了您的问题。
function CHECK_CORRELATION()
{
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var lc = sheet.getLastColumn();
var lr = sheet.getLastRow();
var rangeData = sheet.getRange(2, 1, lr -1, lc);
var lastColumn = rangeData.getLastColumn();
var lastRow = rangeData.getNumRows();
var counter = 0;
var counter2 = 0;
var values = rangeData.getValues();
for (var j = 0; j < values.length; j++)
{
var row = values[j];
var dataToCheck = row[7];
if ((dataToCheck != "" || dataToCheck != undefined) && dataToCheck >= 0.9 && dataToCheck <= 1.1)
{
counter++;
}
else
{
counter2++;
}
}
Logger.log(counter)
Logger.log(counter2)
if (counter>(counter2/2))
{
return "The idea that a student will have motivation and has a part time job co-occur"
}
else
{
return "The idea that a student will have motivation and has a part time job does not co-occur"
}
}
推荐阅读
- angularjs - AngularJS - 如何在路由解析中调用端点?
- r - R TclTk GUI 关闭时调用命令
- linux - AWK 命令返回 0
- python - Flask 端点与 Sagemaker 端点
- accessibility - 您是否需要使用键盘快捷键来遵守 WCAG 2.1 AA?
- sql - 在 SQL 数据库中查找最近的飞行常客
- postman - 如何更新请求的 json 正文中的变量值(时间增量)
- c++ - 如何禁用在第三方代码中重新启用的警告?
- neo4j - neo4j 中的未知函数“apoc.date.format”
- c# - 如何将具有空值的标头添加到 http 响应(Response.Headers)?