Google Sheets转Google Doc模板：自动化脚本无法复制表格问题求助

你的代码仅处理了模板中的段落（getParagraphs()），但Google Docs里的表格是独立元素，不属于段落范畴，因此无法被复制到新文档中。

修改代码逻辑，遍历模板文档主体的所有子元素（包含段落、表格等），而非仅段落。以下是调整后的完整代码：

function myFunction() {
  var docTemplateID = "1oSha1ck2Ritcj7dlXNvLREjvAJhZYD0jQOzkQPbc-10";
  var docFinalID = "1sq0xsbEA0fzciUErAb8J4HlqbEpH9Tmglqch6taqHiI";
  var wsID = "1DCkRQJtftVO1Uy8dSsAkIn2HUzFaXf0KuwcbFsqcXP8";

  var docTemplate = DocumentApp.openById(docTemplateID);
  var docFinal = DocumentApp.openById(docFinalID);
  var ws = SpreadsheetApp.openById(wsID).getSheetByName("StudentResults");

  var data = ws.getRange(2, 1, ws.getLastRow() - 1, 26).getValues();
  var templateBody = docTemplate.getBody();

  docFinal.getBody().clear();

  data.forEach(function(r) {
    createReport(r[0], r[1], r[10], r[8], r[9], r[13], r[11], r[12], r[4], r[2], r[3], r[7], r[5], r[6], r[18], r[19], r[25], templateBody, docFinal);
  });
}

function createReport(first, last, rawoverall2, rawela2, rawmath2, overallscaled2, scaledela2, scaledmath2, rawoverall1, rawela1, rawmath1, overallscaled1, scaledela1, scaledmath1, attendance, homework, notes, templateBody, docFinal) {
  var numChildren = templateBody.getNumChildren();
  
  for (var i = 0; i < numChildren; i++) {
    var child = templateBody.getChild(i);
    var copiedChild = copyAndReplaceText(child, {
      "{first}": first,
      "{last}": last,
      "{rawoverall2}": rawoverall2,
      "{rawela2}": rawela2,
      "{rawmath2}": rawmath2,
      "{overallscaled2}": overallscaled2,
      "{scaledela2}": scaledela2,
      "{scaledmath2}": scaledmath2,
      "{rawoverall1}": rawoverall1,
      "{rawela1}": rawela1,
      "{rawmath1}": rawmath1,
      "{overallscaled1}": overallscaled1,
      "{scaledela1}": scaledela1,
      "{scaledmath1}": scaledmath1,
      "{attendance}": attendance,
      "{homework}": homework,
      "{notes}": notes
    });
    
    if (copiedChild) {
      docFinal.getBody().appendChild(copiedChild);
    }
  }
  
  docFinal.getBody().appendPageBreak();
}

// 辅助函数：复制元素并替换文本，兼容段落和表格
function copyAndReplaceText(element, replacements) {
  var copiedElement = element.copy();
  
  // 处理段落文本替换
  if (copiedElement.getType() === DocumentApp.ElementType.PARAGRAPH) {
    for (var key in replacements) {
      copiedElement.replaceText(key, replacements[key]);
    }
  }
  // 处理表格内的文本替换
  else if (copiedElement.getType() === DocumentApp.ElementType.TABLE) {
    var table = copiedElement;
    var numRows = table.getNumRows();
    
    for (var r = 0; r < numRows; r++) {
      var row = table.getRow(r);
      var numCells = row.getNumCells();
      
      for (var c = 0; c < numCells; c++) {
        var cell = row.getCell(c);
        var cellText = cell.getText();
        
        for (var key in replacements) {
          if (cellText.includes(key)) {
            cell.setText(cellText.replace(new RegExp(key, 'g'), replacements[key]));
          }
        }
      }
    }
  }
  
  return copiedElement;
}

• 替换原有的getParagraphs()逻辑，改为遍历模板主体的所有子元素（通过getNumChildren()和getChild(i)实现）
• 新增copyAndReplaceText辅助函数，分别处理段落和表格的文本替换逻辑
• 表格处理部分会遍历每个单元格，替换其中的占位符内容

修改后，模板中的表格会被完整复制到新文档，同时表格内的占位符也能被正确替换。

内容的提问来源于stack exchange，提问作者Michaela Schwartz