Excel output to existing template

Question

Hello great minds,

I have a workflow that produces table with 10 fields. (Value 1, Value 2, Value 3 etc.) and N amount of rows. I also have an excel called "Calculator", where cells B4:W(N) contains calculations with values of Alteryx output. Is it possible to output the table from Alteryx to the Calculator Excel directly to fields B15:W25, so that I wouldn't have to manually copy the values from Alteryx output to Excel?

Thanks a lot in advance!

alexnajm · Accepted Answer

Yes you can - when you configure the Output Data tool to write out to the Excel file, you'll have the option to insert the range. Here, I would specify B4 and then W:1000 - this is just a high number to make sure it'll accommodate as many rows as needed.