Please check your excel sheet. It seems that you have two columns with the same name.
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
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.
Just give the Range as
"A4" and try it
HCMJoinersAssignment1Performer.zip (2.8 MB)
Hi @Gokul001 i am sharing my code here can you plz help me out
Check out the screenshot
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.