SOLVED
Add tables to an existing excel sheet
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jperles
5 - Atom
‎03-07-2024
01:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is it possible to add a table in a specific position of an existing Excel sheet?
I would need to update an Excel table that I have but without modifying everything else in the sheet
Solved! Go to Solution.
Labels:
- Labels:
- Output
2 REPLIES 2
sparksun
11 - Bolide
‎03-07-2024
02:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Surely you can do it just by using Output tool with the following setting and options:
1 Assign the range where you want to the table appear in
2 Output options:Overrite sheet or range
3 With Preserve Formatting on Overwrite (Range Required) checked
kamal03
9 - Comet
‎03-07-2024
02:10 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jperles
Yes you can do it by using the below configuration in the Alteryx workflow.
In the below i have specified the range where i need to placed the table in the existing excel file. Hope this helps
