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).
if you want to rename the headers which already there
you can try this
DataTableVar.Columns(“yourOldColumnName”).ColumName = “YourNewColumName”
Its working. Thank you for the solution
Please mark the post as solution and close the topic.
Can you provide with sample short WF
How can we use this…im not getting how to implement
give me a minute!
Re-Name Column Names.xaml (6.2 KB)
cheers @Mayyur @swapnil.sonawane
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 ?
did you get any solution for this?
Hi @swapnil.sonawane ,
Take a look on this post.