Workflow Output

[knnwndlm]

Hello,

I've attached an Excel file with three tabs - Wanted Result, Output Data, and Render.  I used the Output Data tool and the Render tool to get two separate results, but what I really wanted is something like the Wanted Result tab.  Also, when I used the Output Data tool to update starting on row 2 each time, I kept getting an error.

Could somebody please help me understand how to use the Reporting tools?

Thanks,

Konn

[Robin_McIntosh]

So you are wanting the Excel to have the specific formatting?  An easy way to do it is to create an Excel file with the formattting in place; first row bold/center/color and then the desired columns formatted for centering, etc.  Save the attached Excel file that is already formatted to a location.  Then in your Output Tool, select this pre-formatted file but be sure to check the option for Overwrite Sheet or Range and then check the box for Preserve formatting on Overwrite.