How to output data to excel starting on a specific row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Could someone please inform me how I can output my data to an existing excel file starting on row #59?
Thank you,
- Stuart
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @jamielaird! This worked.
