Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Write to excel table

msve
8 - Asteroid

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. 

6 REPLIES 6
Raj
16 - Nebula

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.

Raj
16 - Nebula
msve
8 - Asteroid

Thank you, that worked.

Eli_B
10 - Fireball

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.

1.JPG

LucianoGomes
7 - Meteor

Hey, @Eli_B, do you know if there is a way to save to an actual Excel table?
Thanks,

Eli_B
10 - Fireball

Hi! I have not found one to write to an actual Excel table, sorry.

Labels