Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Output data without column headings to Excel

buddy_jones
7 - Meteor

I want to output a data file to a specified range within an Excel worksheet WITHOUT the column headings.  Is that possible?

4 REPLIES 4
CharlieS
17 - Castor
17 - Castor

I don't think it's possible to omit the field name/header from the Output tool when writing an xlsx file like it is with a csv.

 

I suggest using a Dynamic Rename tool to do this before the Output tool. Set the tool to "Take Field Names from First Row of Data" and that will rename the field names with the first row (effectively omitting the headings from the output). 

danilang
19 - Altair
19 - Altair

Hi @buddy_jones 

 

As usual, @CharlieS has a great solution to a tricky problem.   The only possible problem here is if your first row has duplicate values.  The second of these will be renamed usually with "_2".  You will get a warning in your workflow

 

Another option, unless the requirement specifically calls for excel is to output as csv.  Most users have file associations set so that .csv files open in Excel anyway.  

 

Dan

buddy_jones
7 - Meteor

Thanks, Charlie.  I think the .csv approach might have worked for me.  I went ahead and created a set of dummy rows in my data file just before the crosstab so that I would get the full set of column headers that I need.  I then filter out the row that contained the dummy data. 

 

Buddy

MarshallG
8 - Asteroid

Not sure in what version this was added, but as of 2019.3, this is easily do-able with regular 'Output Data' tool options.

 

Select the 'Skip Field Names' box in the Output tool (highlighted below).

 

If writing to a specific cell or range in an Excel file, enter the cell (or range) into the output filepath. Here I've output a single cell of data from my workflow to C3 of an Excel file.

 

MarshallG_0-1576092018043.png

Labels