Add column header from excel

[Chendoran_M]

Hi, Guys.

How do I add column header in “Build Data Table” activity from an excel sheet?
(There are around 200 column headers in excel sheet.)

Thankyou.

[supermanPunch (Arpan)]

Hi @Chendoran_M ,

Could you let us know what is the purpose of adding it to a New Datatable ?

We could use Read Range Activity and read the data as a Datatable, if the data is also required further for processing.

We could then Clone this Datatable to get the Schema/Column Names from it.

Another method would be to use Read Row Activity and get the Starting row/Header data from the Excel sheet as an Array.
Then loop through the array data using For Each Activity and use Add Data Column Activity to add column to the Datatable.

[maheshwari.sonawane]

You can read the excel with column names by read range.
Use for each loop with add data column activity in it

[Chendoran_M]

Is this flow correct?

[supermanPunch (Arpan)]

@Chendoran_M ,

You would need to just Read the Excel sheet and use an Assign for creating the Clone of Datatable as shown in the image below :