异常:无法检索下一个对象:迭代器已到达末尾.第26行错误

Question

function sendMail() {
var ofo = 1;
var restaurant = 2;
var name = 3;
var email = 4;
var sent = 5;
var emailTemp = HtmlService.createTemplateFromFile("Email");
var ws = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Invalid Login MM Pull Internal");
var data = ws.getRange("A2:F" + ws.getLastRow()).getValues();
data.forEach(function(row){
emailTemp.ofo = row[ofo];
var file = DriveApp.getFilesByName("Guide to Resetting Online Delivery Passwords.pdf");
var htmlMessage = emailTemp.evaluate().getContent();
var startRow = 2;
for (var i = 0; i < data.length; ++i){
if (row[sent] !== "EMAIL_SENT"){
GmailApp.sendEmail(row[email], "Otter Onboarding: Invalid " + row[ofo] + " Logins Submitted", 
"Your email doesn't support HTML, please trying using another browser.",
{name: "The Otter Onboarding team", 
htmlBody: htmlMessage, replyTo: "[e-mail]",
attachments: [file.next().getAs(MimeType.PDF)]
});
ws.getRange(2 + i,6).setValue("EMAIL_SENT");
};
};
});
}

我试图将此PDF附加到我的电子邮件中，但它一直在第26行显示错误：异常：无法检索下一个对象：迭代器已到达末尾

Answer 1

只是猜测。取而代之的是：

var file = DriveApp.getFilesByName("Guide to Resetting Online Delivery Passwords.pdf");
...
attachments: [file.next().getAs(MimeType.PDF)]

你可能需要这个：

var file = DriveApp.getFilesByName("Guide to Resetting Online Delivery Passwords.pdf").next();
...
attachments: [file.getAs(MimeType.PDF)]

getFiles()为您提供了一个迭代器(类似于数组(。方法.next()为您提供了迭代器的第一个(实际上只是(元素。