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”

2 Likes

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…

Select the check-box for AddHeaders within ExcelWriteRange Activity as shown below:

2 Likes

what if we want to add headers in different sheets of same excels that already contains information in it

could you explain me sir about this ?

regards ,

did you get any solution for this?

Hi @swapnil.sonawane ,

Take a look on this post.

Regards
Balamurugan.S