Pre populating an excel sheet title in first row while using a rendor tool to output data

[gjlomuti]

Hey all,

I was curious to know if the render tool or any other reporting tool gives you the ability to input a prepopulated title for an excel sheet. I am using the layout tool along with the render tool to ouput excel sheets to a workbook but wasnt sure if i was able to title each table in the specific sheet. For example, in the screenshot below I want to somehow write out the "Title" and "by" into the alteryx workflow so I dont have to go inot excel and manually do it. Anyone know how to add this?

[pedrodrfaria]

Hi @gjlomuti 

You would be looking probably at the Report Tool as a solution. With it, you can write what you want inside of the workflow. You can even use the data information to create dynamic fields if you select the Available Fields dropdown.

[gjlomuti]

How would this work if I already have a layout and render tool in place? would I be able to make different titles for each sheet?

[pedrodrfaria · Accepted solution]

Hi @gjlomuti 

You can, I would recommend you to put before the layout.

I attached a WF that should be a good guide for you.

[gjlomuti]

Works great! Thanks!