Column 'XYZ' Doesnt't belong to the table

[Lukasz_Krasniak (Łukasz Kraśniak)]

Hello,

I have a problem with my robot
When I try to compile, I get an error:
RemoteException wrapping System.ArgumentException: Column ‘first name’ does not belong to table DataTable.
at UiPath.Core.Activities.ScopeActivity.OnFaulted(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.Invoke(NativeActivityFaultContext faultContext, Exception propagatedException, ActivityInstance propagatedFrom)
at System.Activities.Runtime.FaultCallbackWrapper.FaultWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

This is my excel file:

first name last name gender address city state home phone work phone work email personal email

I am trying to create a robot that captures data from excel
Below is an part my robot which is the problem

In my opinion the problem is text int the field type into : customersData(rowNumber)(“first name”).toString

[Lukasz_Krasniak (Łukasz Kraśniak)]

I don’t know how to change customersData (rowNumber) (“last name”). ToString

to make it work

[prasath_S]

Hi @Lukasz_Krasniak

Is this inside for each row and also is first name column present in the datatable…

[Lukasz_Krasniak (Łukasz Kraśniak)]

@prasath_S

Is this inside for each row and also is first name column present in the datatable…

Yes, the problem is for each row If i try rename of column

[ppr (Peter)]

@Lukasz_Krasniak
check the EXCEL in the first row if the values taken for the column names are free of surrounding spaces etc.
Ensure Add header is ticked on for read range

in case it is not working after this:

• debug the bot and inspect the content of the datatable
• use immediate panel and type in youdDataTableVar.Columns(0).ColumnName and inspect the column name returned from this

[Lukasz_Krasniak (Łukasz Kraśniak)]

I did debugging my project and I have information that my whole robot ‘dooesn’t belong to DataTable’

There is no empty space in the excel file

[prasath_S]

Can you show the excel file you are reading…

[Lukasz_Krasniak (Łukasz Kraśniak)]

YES NO PROBLEM

[prasath_S]

Just to check In read range have you checked Addheader property…

[Lukasz_Krasniak (Łukasz Kraśniak)]

Thanks @prasath_S Actually, the Addheader checkbox was unchecked and it worked
Thanks so much !!!