How to output data to excel starting on a specific row

[Stuart_C]

Hi,

Could someone please inform me how I can output my data to an existing excel file starting on row #59?

Thank you,

- Stuart

[jamielaird · Accepted solution]

Hi @Stuart_C 

You can do this using by specifying a named range when you select the existing Excel file that you want to write to:

Cell XFD1048576 is the last possible cell in the most common version of an XLSX file, so what you're effectively telling Alteryx to do is to write your data anywhere below row 59.

I've attached an example - place the Excel file in the same directory as the workflow.

If you play around with the Excel file and add some text above row 59, you should see that this is maintained after running the workflow.

[Stuart_C]

Thank you @jamielaird!  This worked.