How to add the header in excel

Help
1

How to add the header in excel?

2

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
3

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

2 Likes
4

Its working. Thank you for the solution

1 Like
5

Please mark the post as solution and close the topic.

Regards,
Karthik Byggari

6

Can you provide with sample short WF

7

what!!?

8

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

9

give me a minute!

1 Like
10

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

2 Likes
11

Thank you…

12

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

image
image1142×402 18.3 KB

2 Likes
13

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 ,

14

did you get any solution for this?

15

Hi @swapnil.sonawane ,

Take a look on this post.

Regards
Balamurugan.S