Hello guys
I have an excel file, and I want to know each data belongs to which column?
for example, if the data in A it should print A if in B column should print B and so on so forth
Please help me?
Hi @marwan992,
You can make use of the following snippet by providing column headers.
- Get all column names
- Loop through column names
- For each row
- Get row item
- If condition to check value exists
- Matches breaks the loop
Please find the image for reference.
i have problem with this instruction, contains is not a member of system.datatable
Please check the image for reference, you can use for loop to find the column.
what is the type for dc ??
DataColumnCollection
in the get row item i am facing error when i pass row in the activity ?
Use only row in the get row item and in the properties for Column you pass item
still showing an error
send me screenshot of the error
In For each loop, change the type from object to datacolumn
I think you need to initialize datatable
Is that value null or blank? In that case it may throw this error I think.
hello @marwan992
Please assign a variable(Output) to Get Row Item Activity and then use that variable in IF Activity
Object Reference Not Set To An Instance Of An Object This error occurs whenever certain activity does not get value for further processing
found the solution thanks a lot