Write an Excel output Without a Headerline

[kelkboom]

Hello, 

Is it possible to write an Excel file without inserting the Headerline (Column names) in the output file..

Regards Humberto 

[pcatterson]

I don't know a way to do this with the typical output tool, but you could use a browse and copy out the "All Records without Headers" or "Selected Cells without Headers" to accomplish this.

[Garrett · Accepted solution]

First thing that comes to mind as a workaround would be to insert a Dynamic Rename tool immediately prior to the Output Data tool.  Configure it to 'Take Field Names From First Row of Data'.

[pcatterson]

One potential issue would be if the first row of data had any duplicates in it.  You cannot have duplicate names for headers and then your excel wouldn't be 100% what you started with.

[Garrett]

What about sending the data through a Table and Render tool?  Might have to spend some time dialing back the formatting, but the Table tool lets you decide whether or not to 'Show Column Headings'.