Write to excel table
- 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
I have a workflow that writes the data to excel but its not preserving the excel table format. The issue is the table that Alteryx creates doesn't have a name; if you click in on the cells in Excel, the Table Manager menu doesn't appear, and it doesn't show up in the Name Manager. Is there a way for Alteryx to create a table in excel? I have attached my workflow for reference.
Solved! Go to Solution.
- Labels:
- Best Practices
- Common Use Cases
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, in Alteryx, you can create an Excel table by using the "Output Data" tool and configuring it to output the data as an Excel table
do you have a template where you want to update the values? if yes then this become even easier
you just need to select the file and the specific range and preserve the formatting in the configuration tab.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Data Output to Template Excel File in Alteryx Designer (youtube.com)
you can reffer this as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, that worked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was a misleading answer. Excel can contain actual "tables". All this solution is doing is writing to specific Excel cells, not actual Excel Tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey, @Eli_B, do you know if there is a way to save to an actual Excel table?
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi! I have not found one to write to an actual Excel table, sorry.
