Custom Output via Excel Template

[akvsachin]

The workflow begins with dynamic input retrieval using the File Browse tool, which updates the Input Data tool containing the sample input file. Next, we move on to data preparation, including Group-By operations, Subtotals, and Grand Totals.

In Step 1, we copy the template to apply the desired formatting, such as alignments, currency symbols, and alternate row colors. At this point, the workflow branches into two connections:

1. One connection leads to the CMD tool, which copies the data.
2. The other connection goes to a container that overwrites the template.

To include a footnote, we use another container where the Text Input tool appends the footnote to the data range, adjusting the range by +1.

A Block Until Done macro ensures sequential execution:

• First, it prints the footnote output as prepared in the container.
• Then, it prints the second output, which retains the template formatting while displaying all data along with the footnote.

The only remaining requirement is to limit the alternate row colors in the template to the data range.

I can't share the workflow, so attaching an image of the workflow. and a sample output file that has the same conditional formatting as the template.

 

[The_Rad_Valentina · Accepted solution]

I would recommend using a Blob Input and Output tool where you are configuring formatting for your data including the alternate row colors and then write out your data to a range. Here's an article on how the Blob tool works. 

The Blob: Reporting That Isn’t From a Horror Film - Alteryx Community

If this response was helpful, please accept it as a solution.