将电子表格中的表格以及其他一些列发送到文档

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

---

想要改进这个问题吗？通过编辑这篇文章来更新问题，使其仅关注一个问题。

2 年前已关闭。

Answer 1

将表格保存在 doc 中并发送

function myfunk() {
  const ss = SpreadsheetApp.getActive();
  const doc = DocumentApp.create("Sample");
  const sh = ss.getSheetByName("Sheet1");
  const vs = sh.getRange("A2:F10").getValues();
  doc.getBody().appendTable(vs);
  doc.getBlob().getAs('application/pdf');
  doc.saveAndClose();
  GmailApp.sendEmail("[email protected],"Data your looking for","Hi Bob: Here it is",{attachments:[doc]});
}