Colunmn name already belong to datable exception while reading excel in reframework

Hi @Sandhya_Gajare

Please check your excel sheet. It seems that you have two columns with the same name.

HI @Sandhya_Gajare

This error saying that you Duplicate column name in the excel file

can anybody guide me on this exception i have try to uncheck header that type it’s work fine but whenever i am going to check add header property its,throwing me exception but in future i need header

You have the Duplicate column name in the excel Try to Rename the Duplicate columns manually and try it @Sandhya_Gajare

this my excel and i am trying to read the same and i don’t found any duplicate colunm

@Sandhya_Gajare

From your screenshot, you have to set the Range field of activity to “A4:J”. Where is the number of last row you want to read from excel sheet

Right now when you specified “” which means that you want to read the whole sheet.
Since all the columns from A1 to J1 habe the same value, UiPath reads it as you’d name all the columns exactly the same.

If you set range field to “A4:J13”, and set the “Add Headers” option UiPath will read values from A4 to J4 as column names, and values from A5 to J13 as data.

Hi @Sandhya_Gajare

Just give the Range as "A4" and try it

1 Like

HCMJoinersAssignment1Performer.zip (2.8 MB)
Hi @Gokul001 i am sharing my code here can you plz help me out

HI @Sandhya_Gajare

Check out the screenshot

Regards
Gokul

1 Like

Thanks lot.

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