Duplicate

Help Studio
, ,
1

If in excel duplicate column is there then can we read excel?
and how

2

I dont think, the UiPath will allow that, either you need to rename one of the duplicate column

3

HI @Babita_Shinde

If there is a duplicate columns in excel it will read. But the file should exist.

Regards.

4

can you elaborate please

5

@Babita_Shinde

You can still read the excel but with headers column unchecked as if two column names are same then it wild fail…so read without headers

Cheers

1 Like
6

will I able to read because value also can duplicate

7

Yes @Babita_Shinde if there is any duplicates in the excel file you are able to read the excel file.
And there is a activity to remove the duplicates “Remove Duplicates” activity.

8

@Babita_Shinde : In order to use the excel file, you will need headers, so duplicate headers not allowed in UiPath, as per my knowledge, you might need to rename the column

9

@Babita_Shinde

If you dont read headers then you can read the data from excel without any issues

Cheers

10

I need read with headers

11

@Babita_Shinde

Then you need to replace the name of duplicate headers

You cannot read with headers if name is same

Cheers

12

Okay, Thank you