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
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.
Regards,
Karthik Byggari
Can you provide with sample short WF
what!!?
give me a minute!
Thank you…
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?