Check Value from excel

@arpita2,

Can you please follow my steps,

  1. Use Read Range activity to get the DataTable from your specified Excel file.
  2. 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.
  3. Use IF condition to find: rowValue.equals(myVaraible.toString())

I have created sample workflow your query. I hope it will solve your doubt :grinning:

FindValueInExcel.zip (8.3 KB)

Thanks,
Arunachalam.

3 Likes