在將特定的谷歌表（電子郵件）作為 Excel 附件發送時，我在此代碼中遇到了一個問題。
function sendReport() {
SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data").hideSheet();
var message = {
to: "[email protected]",
subject: "Weekly Reports",
body: "Hi Team,\n\nPlease find attached summary reports, Thanks!\n\nThank you,\nMyNameHere",
name: "MyNameHere",
attachments: [SpreadsheetApp.getActiveSpreadsheet().getSheetByName("EMAIL").getAs(MimeType.xlsx).setName("Weekly Report")]
}
MailApp.sendEmail(message);
SpreadsheetApp.getActiveSpreadsheet().getSheetByName("EMAIL").activate();
}
我面臨的錯誤是：
8:36:26 PM Notice Execution started
8:36:27 PM Error TypeError: SpreadsheetApp.getActiveSpreadsheet(...).getSheetByName(...).getAs is not a function
sendReport @ script.gs:10
移除后
.getSheetByName("EMAIL")
從第 10 行開始，錯誤如下：
8:38:43 PM Notice Execution started
8:38:43 PM Error Exception: Invalid argument
sendReport @ script.gs:10
uj5u.com熱心網友回復：
為什么你遇到過這種錯誤的原因是因為沒有getAs()在
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/348856.html
下一篇：創建父檔案夾時創建子檔案夾