Add column name for newly added column in excel

Help
1

I need to give column name for a column that I recently added to excel sheet ? Any guidance ?

2

to rename directly in excel sheet, you can use write cell activity

To rename column name in a datatable, you can use
Dt.Columns(0).ColumnName = “newColumnName”
Where 0 is the index of the column to be renamed.

image

4 Likes
3

While adding new column to datatable itself you can provide name…

3 Likes
4

Thanks Farhan

5

thanks @Divyashreem

1 Like
6

How do you do that?

7

@farhi
To create a new column we will be using add data column whre you can mention the name as @Divyashreem mentioned in the column name property like this
image

Cheers

8

So this is added inside the excel application scope activity?
Sorry I am new to rpa.

9

Not necessary to be in excel application scope buddy

10

Alright! Thanks.