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
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.