Excel Output with Reporting Tool with default excel border layout and 2 blank line spacing

Question

Hi Team,

Kindly note that I need to output data in excel using Reporting tools such that:

* Row 1 - Row 6 : Font: Times New Roman and Bold, Size, 12pt and Bolor: Dark Blue, Align: Left
* Row 7  till last row: Font: Times New Roman and Bold, Size, 10pt, Align: As shown in the output file
* Row 7 : Font: Times New Roman and Bold, Size, 10pt, Align: As shown in the output file
* Column F - Column K - to be output in Accounting format
* Subtotal and Grand Total to be Bold and with border for required columns only
* Bacground of the excel sheet should look exactly as normal excel with grey borders
* 2 Blank Rows after each Total for each Scrip Name should be clearly visible

I am shairng the reference files:

* Input file: Input.xlsx
* Ouput file: Render Tool Output.xlsx (Showcasing the desired output needed from alteryx)

Kindly advise if this can be achieve in Alteryx using Reporting Tools?

Input.xlsx

Render Tool Output.xlsx

jdminton · Answer

@Tej_Singh  Try the attached workflow. You may need to play with column widths, but this is pretty close to the results in your Excel example. Let me know if it works or if you have any trouble.

Report Render xlsx.yxmd

Tej_Singh · Answer

Thanks for the reply @binu_acs . I am unable to get the exact desired output using Table tool hence thought of checking for solution. If you can provide a solution as a Workflow then that would be really helpful?  Let me know if it's doable.

binu_acs · Answer

@Tej_Singh The Table tool can format your data according to your requirements. Just explore the table tool properties