How can I generate a multipage text document from a single page template in google-apps-script?

Question

I have to generate labels from a list of user data stored in a spreadsheet. Right now I get everything working nicely except that when I output more than 16 items (the number of labels per page) I have more than one document, each of them being a single page. Each doc has a unique name so it's not very hard to use but it's kind of boring to open so many documents to print them. Since I don't want to create a template of 500 items (or whatever number) I was wondering if I could repeat this single page template in a multi-page document to any extend so I get all the labels in one single document. This would be far more comfortable to print ;-) I couldn't find any clue up to now... any brilliant idea ? here is the code I use to generate the docs ( a bit long, sorry about that) : and ... many thanks for any help. ``` function print(e){ var app = UiApp.getActiveApplication(); var selrangerow = sh.getActiveSelection().getRowIndex(); var selrangeheight = sh.getActiveSelection().getNumRows();…

Accepted Answer

Well Serge, haven't you tried the `appendParagraph` and other appends of the DocumentBodySection?

I'd do it like this:

```
function mergeDocs() {
  var docIDs = ['list-of','documents','ids','you should have somehow'];
  var baseDoc = DocumentApp.openById(docIDs[0]);
  var body = baseDoc.getActiveSection();

for( var i = 1; i < docIDs.length; ++i ) {
    var otherBody = DocumentApp.openById(docIDs[i]).getActiveSection();
    var totalElements = otherBody.getNumChildren();
    for( var j = 0; j < totalElements; ++j ) {
      var element = otherBody.getChild(j).copy();
      var type = element.getType();
      if( type == DocumentApp.ElementType.PARAGRAPH )
        body.appendParagraph(element);
      else if( type == DocumentApp.ElementType.TABLE )
        body.appendTable(element);
      else if( type == DocumentApp.ElementType.LIST_ITEM )
        body.appendListItem(element);
      else
        throw new Error("According to the doc this type couldn't appear in the body: "+type);
    }
  }
}
```

How can I generate a multipage text document from a single page template in google-apps-script?

Solution

Problem