Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Enter headers rows on excel (xlsx) output files

ryanheite
5 - Atom

I am just curious if there is a way to add 2 rows to the top of my data output excel file.  I have looked at the render and header tools but I don't think those are what I need for this.  I have this report fully automated with Alteryx and was just wondering if there could be a way to eliminate the final manual step.  In the screenshot of my excel book attached I am curious if there is a way to have Alteryx create the first 2 rows, which is my title of the data set and range of the sales data.  Currently I run my workflow then insert these 2 rows manually after Alteryx creates them.  Any help would be greatly appreciated.  Please and thank you.   

 

 

1 REPLY 1
OTrieger
12 - Quasar

Hello @ryanheite 

One way to do it is to use Blob tool. By creating a blank template of the excel file with all the colours and font setting, you could call to that template, write it out and then fill in the data to specific ranges. In that manager you could adjust the first 2 lines with the most current data and then write out the rest of the data bellow.

Labels
Top Solution Authors