如何添加单条代码移除证书生成文档开头换行且不破坏格式？

我用ChatGPT编写了一段Google Apps Script脚本，可基于电子表格数据和证书模板批量生成证书并合并为单个文档，方便打印。脚本功能正常，但生成的文档开头始终存在一个多余换行，导致证书打印时与纸质模板错位。我尝试过使用allCertificatesBody.setText(content.substring(1))代码，但该操作会完全破坏证书的字体、间距等格式（需保持特定格式适配纸质证书）。由于脚本是为电脑操作不熟练的用户设计，需实现自动化处理，现询问是否可添加单条代码解决该问题？

问题根源是新建的Google Docs文档默认会包含一个空段落，这个段落就是开头多余换行的来源。你只需要在创建最终文档后，添加一行代码删除这个默认的空段落即可，不会破坏任何已有格式：

allCertificatesBody.removeChild(allCertificatesBody.getChild(0));

将这行代码插入到设置页面方向和边距的代码之后、初始化firstCertificate变量之前即可。

修改后的完整脚本 #

function generateCertificates() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Master");
  var templateId = '1JqoZVyfEh6UZNeEmTIC1rTe04PSu7WhM3KFozDkOBvQ'; // Template document ID
  var dateValue = formatDate(sheet.getRange("AB1").getValue()); // Date from cell AB1 formatted as "MMMM dd yyyy"

  // Get all data from columns B, C, D, and J
  var dataRange = sheet.getRange("B2:J" + sheet.getLastRow()).getValues();

  // Create the final document
  var allCertificatesDoc = DocumentApp.create(dateValue + " certificates");
  var allCertificatesBody = allCertificatesDoc.getBody();

  // Set the final document to landscape and set margins to 0
  allCertificatesBody.setPageHeight(612).setPageWidth(792); // 792x612 is landscape
  allCertificatesBody.setMarginTop(0).setMarginBottom(0).setMarginLeft(0).setMarginRight(0);

  // 移除新建文档默认的空段落，解决开头多余换行问题
  allCertificatesBody.removeChild(allCertificatesBody.getChild(0));

  var firstCertificate = true;

  // Loop through the data to find rows with true in column J
  for (var i = 0; i < dataRange.length; i++) {
    if (dataRange[i][8] === true) { // Check if the checkbox in column J is checked
      var firstName = dataRange[i][0];
      var lastName = dataRange[i][1];
      var promotionDetails = dataRange[i][2].split(' ');
      var firstPart = promotionDetails[0];
      var secondPart = promotionDetails.slice(1).join(' ');
      var fullName = firstName + " " + lastName;

      // Open the template document
      var templateDoc = DocumentApp.openById(templateId);
      var templateBody = templateDoc.getBody();

      // Create a temporary document to hold the modified content
      var tempDoc = DocumentApp.create('Temp Doc');
      var tempBody = tempDoc.getBody();

      // Copy the template content to the temporary document
      copyBodyContent(templateBody, tempBody);

      // Replace placeholders with actual data in the temporary document
      tempBody.replaceText('{{Full_Name}}', fullName)
             .replaceText('{{Promotion_First_Part}}', firstPart)
             .replaceText('{{Promotion_Second_Part}}', secondPart)
             .replaceText('{{Date}}', dateValue);

      // Append the modified content to the final document without introducing extra line breaks
      if (!firstCertificate) {
        allCertificatesBody.appendPageBreak();
      } else {
        firstCertificate = false;
      }

      // Append paragraphs from the temporary document to the final document
      copyBodyContent(tempBody, allCertificatesBody);

      // Delete the temporary document
      DriveApp.getFileById(tempDoc.getId()).setTrashed(true);
    }
  }

  // Save the final document with the correct name
  var finalDocFile = DriveApp.getFileById(allCertificatesDoc.getId());
  finalDocFile.setName(dateValue + " certificates");
}

// Helper function to format the date as "MMMM dd yyyy"
function formatDate(date) {
  return Utilities.formatDate(date, Session.getScriptTimeZone(), "MMMM dd yyyy");
}

// Helper function to copy body content from one document to another
function copyBodyContent(sourceBody, targetBody) {
  var totalElements = sourceBody.getNumChildren();
  for (var i = 0; i < totalElements; i++) {
    var element = sourceBody.getChild(i).copy();
    targetBody.appendParagraph(element);
  }
}

说明 #

这行代码仅删除新建文档自带的空段落，不会影响后续从模板复制过来的带格式内容，完全满足自动化需求，用户无需额外操作。

内容的提问来源于stack exchange，提问作者HyungJin Kim