我想将Google脚本中的数据加载到HTML文档中并通过电子邮件发送。当我运行下面的代码时,出现错误ReferenceError: "document" is not defined.
。
我不了解错误的原因或解决方法。
我的GS脚本:
function sendEmail(){
//Email Template
var emailTemp = HtmlService.createTemplateFromFile("template"); // access to the HTML document
// Tab Stichprobe
var stichprobe = Spreadsheetapp.getactiveSpreadsheet().getSheetByName("Stichprobe");
var stichprobecapital = stichprobe.getRange("A2:L"+stichprobe.getLastRow()).getDisplayValues(); // Array AssetName
var software = Spreadsheetapp.getactiveSpreadsheet().getSheetByName("Software");
var softwarecapital = software.getRange("A2:E"+software.getLastRow()).getDisplayValues();
var test=[];
var stichprobelen = stichprobe.getRange("A2:A"+stichprobe.getLastRow()).getDisplayValues().length;
var softwarelen = software.getRange("A2:A"+software.getLastRow()).getDisplayValues().length;
var softwareindex = [];
//Config
var config = Spreadsheetapp.getactiveSpreadsheet().getSheetByName("Config");
var subject = config.getRange("B1:B1").getvalue();
var counter = config.getRange("B5:B5").getvalue();
var subject = config.getRange("B1:B1").getvalue();
var replyto = config.getRange("B3:B3").getvalue();
var name = config.getRange("B2:B2").getvalue();
var error = config.getRange("B6:B6").getvalue();
var cc = config.getRange("B4:B4").getvalue();
for (var a = 0; a<stichprobelen; a++){
for (var i = 0; i<softwarelen; i++){
if (softwarecapital[i][0] == stichprobecapital[a][0]){
softwareindex.push(i);
}
}
var softindexlen = softwareindex.length;
for(var b = 0; b < softindexlen; b++) {
var node = document.createElement("LI");
var textnode = document.createTextNode(softwarecapital[0][1]);
node.appendChild(textnode);
document.getElementById("liste").appendChild(node);
}
var htmlMessage = emailTemp.evaluate().getcontent();
GmailApp.sendEmail(stichprobecapital[a][2],subject,error,{name:name,htmlBody: htmlMessage,replyTo: replyto,cc: cc});
}
}
我的HTML脚本:
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<ul id="liste">
</ul>
</body>
</html>
问候