Change duplicate column names

Help Studio
,
1

Can anyone help me how to change repeating column names in excel in ui path.

2

Hi @Gattu_Monika,

I hope this post will give you an idea:

You can then use this in an Assign activity to change the names:

DataTable.Columns(Column Index).ColumnName= 'ABC'

or

DataTable.Columns("columnName").ColumnName= 'ABC'

Thanks,
Neelima.

3

Thanks @1996

4

@Gattu_Monika Hope this will helps, if it works mark it as solution

Thanks!

5

But i would like to know how to find duplicate column names and rename them dynamically

6

Hi ,

I came across the Snippet in the uipath connect .

Can you try this.

7

Yes I will try it. Thanks @Priyanka_Ramesh