下面是导致错误的代码。这似乎正是我试图添加全天活动的地方。需要改变什么来纠正错误,或者错误实际上意味着什么。
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);
}
}