Excel column header name that has "/" character throws a DuplicateNameException error

Help
,
1

Hello,

I’m trying to get UIpath to extract a column name called “Season/Year” at column index 4 inside an Excel file.
image

It should be working normally as the rest of other column, however when UIpath read this particular column it would throw off this error:-
image

So, my initial solution to this problem was removing the “/” inside the “Season/Year” header. and UIPath was able to show output of the column without any issue.
image
image

But I still want to keep the header as it is. Can anybody explain to me why “/” gave me an error and how I could get around it?

2

Can you try manually creating data table (Build Data Table Activity) with column name “Season/Year” and check if it works or not.

1 Like
4

Hi @harizd
First of all this error will not occur if there is no duplicate columns. Can you please check is there any other columns with the same name as Season/Year. When you are removing ‘/’, the column names are differing, hence you are not getting duplicate column error. (If you can upload your excel, we can look into it once.)
You can try with Build data table but that UiPath studio will not allow to Build a datatable with column name having ‘/’.
Other solution to your problem is, when you are reading data from excel, start the range excluding the header and don’t check the Add Header checkbox. Thus you get unique system generated column names for each column(Column0, Column1, Column2,…). Use these column names as key to access you columns,
Hope this is helpful!

2 Likes
5

Ah! there is a duplicate column. I didn’t notice it before :sweat_smile: Thank you for pointing this out

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.