代码之家  ›  专栏  ›  技术社区  ›  Jin

找不到函数createEvent(或createAllDayEvent)。(谷歌电子表格应用)

  •  0
  • Jin  · 技术社区  · 7 年前

    下面是导致错误的代码。这似乎正是我试图添加全天活动的地方。需要改变什么来纠正错误,或者错误实际上意味着什么。

    function SpreadsheetToCalendar3() 
    {
      // This function should be executed from the 
      //  spreadsheet you want to export to the calendar
      var mySpreadsheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("My Calendar-Sheet01");
    
      var myCalendar = CalendarApp.openByName("My Calendar-01");
    
      // optional - delete existing events
      var events = myCalendar.getEvents(new Date("November 1, 2018 EST"),
    new Date("November 1, 2019 EST"));
      for (var i = 0; i < events.length; i++) 
      {
         events[i].deleteEvent();
      }
    
      var dataRange = mySpreadsheet.getRange("A2:B39");
      var data = dataRange.getValues();
    
      // process the data
      for (i in data) 
      {
          var row = data[i];
          // assume that each row contains a date entry and a text entry
          var theDate  = row[1];  // First column of row
          var theTitle = row[0];  // Second column of row
          myCalendar.createAllDayEvent(theTitle, theDate);
      }
    
    }
    
    0 回复  |  直到 7 年前