以下代码针对第 2 列和第 3 列中的数据发送一封电子邮件,但电子邮件中的结果并不在另一个之下。
Code.gs
function email() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var bulk = ss.getSheetByName("Bulk");
var lastrow = bulk.getLastRow();
var data1 = bulk.getRange(1, 2, lastrow).getValues();
var data2 = bulk.getRange(1, 3, lastrow).getValues();
var onedata="", twodata="";
for (var i =1; i < data1.length; i++) {
if (onedata.length) {
onedata += ", ";
}
onedata += data1[i]
}
for (var i =1; i < data2.length; i++) {
if (twodata.length) {
twodata += ", ";
}
twodata += data2[i]
}
var report = ""
report += "<tr><td style='padding:5px'>" + onedata + "</td><td style='padding:5px'>" + twodata + "</td></tr>";
report ="<table><tr><th'>First data</th><th>Second data</th></tr>" + report + "</table>";
MailApp.sendEmail(Session.getActiveUser().getEmail(),
"Your report", report, {htmlBody: report});
}
通过电子邮件收到结果
First data Second data
Apple, Orange, Grapes, Red, Orange, Green, Yellow,
Banana, Chickoo Grey
预期结果
First data Second data
Apple Red
Orange Orange
Grapes Green
Banana Yellow
Chickoo Grey