Can you please follow my steps,
- Use Read Range activity to get the DataTable from your specified Excel file.
- Use For Each row and specify your DataTable variable in the value Text box. Use GET ROW Item Activity to get the value of the specified column.
- Use IF condition to find: rowValue.equals(myVaraible.toString())
I have created sample workflow your query. I hope it will solve your doubt
FindValueInExcel.zip (8.3 KB)
Thanks,
Arunachalam.