dictionary - 为什么这个 Google 应用程序脚本中忽略了“if”？

Question

我正在尝试获取一个电子表格来更新我的 Google 帐户上的日历，但我正在努力使if以下代码的条件正常工作。当我运行inseritoNelCal调试时说它是未指定的，即使电子表格在每一行/列中都有实际数据。

    var IN_CAL = new String('INSERITO');

    function dallaTabellaAlCalendario() {

    var ss = SpreadsheetApp.getActiveSpreadsheet(); 
    var sheet = ss.getActiveSheet();

    var startRow = 2; // First row of data to process
    var numRows = 2; // Number of rows to process

    // Fetch the range of cells A2:B3
    var dataRange = sheet.getRange(startRow, 1, numRows, 3);

    // Fetch values for each row in the Range.
    var data = dataRange.getValues();
    for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var title = row[0]; // First column
    var startTime = new Date(row[1]); // 2nd column
    var endTime = new Date(row[02]); // 3rd column
    var description = row[3]; // 4th column
    var location = row[4]; // 5th column
    var guests = row[5]; // 6th column
    var inseritoNelCal = row[6]; // 7th column
    }

    if (inseritoNelCal != IN_CAL){


 var calendar CalendarApp.getCalendarById("mycalendarID").createEvent(title, startTime, endTime, {Descrizione: description, Luogo: location, Allievi: guests, Inserito: inseritoNelCal });
    sheet.getRange(startRow, 7).setValue(IN_CAL);

    }
    }

标签： dictionarycalendar