How to add the header in excel

How to add the header in excel?

Just insert a row at first row and then use write cell or write range activity to write the headers.
When you use read range activity, set the below option to true (by default it set to true) -

AddHeaders - When selected, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True).

Regards,
Karthik Byggari

2 Likes

if you want to rename the headers which already there
you can try this
DataTableVar.Columns(“yourOldColumnName”).ColumName = "YourNewColumName"

1 Like

Its working. Thank you for the solution

1 Like

Please mark the post as solution and close the topic.

Regards,
Karthik Byggari

Can you provide with sample short WF

what!!?

How can we use this…im not getting how to implement

give me a minute!

1 Like

Re-Name Column Names.xaml (6.2 KB)
cheers @Mayyur @swapnil.sonawane

2 Likes

Thank you…