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

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?

Data Investigation

Accepted answers

pedrodrfaria

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.

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

All comments

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?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335