Get excel headers

How can I get just the headers from my excel file?  

Comments

  • You can get the headers from your excel file in a list by setting up a flow with the Get Row step and the Split String step.

    The step Get Row returns the values from the row as a string. It is listed in the tool box under Data / Excel & CSV.  If you set the input for Row Number to 0 and Ignore First Row set to False, it will return the header values. 

    From there, you can use string manipulation steps such as Split String with a comma as the separator to get each header value and output them as a list of strings. 


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion