How do I Render an Excel file that is formatted to repeat column headings?

Question

My input is a single table of data.  My output contains the data plus various required verbiage in the Header and Footers.  The output is in Excel format and I've successfully rendered the file using Table, Image, Report Text, Layout, and Render Tools.  The next step is for the data headers to be repeated on each page when the document is printed by the recipient of the file.

I don't see any options within the Table Tool to create that format.

apathetichell · Answer

You cannot render and output data. You cannot output data and render. You cannot even use two render tools to the same file (it will overwrite).

rbelski · Answer

The solution by TheMattLeonard sounds possible, but I want to avoid macros at this point.  And, correct me if I'm wrong, but I can't combine an Excel template input (presumably using the Blob Tool) with the Render Tool output.

The solution by Apathetichell sounds intriguing and I may try that at some point.

apathetichell · Answer

is your report verbiage in report header and footer tools?

I'd do something like --> mark header stream as 1. footer stream as 3. append each individual sheet variable (assuming you'll group by this)

table stream as 2. Union all 3. sort by your group by id (should by your sheet variable) and your integer field. use a summarize tool (group by your sheet variable/group id - vertically union your report snippet.

continue with the rest of your workflow.