1.Read your excel using “Read Range” inside “Excel Application Scope”.
2.From data table which is an out argument from “Read Range”.
3.Read data from data table using “for each row” , use a “If” control to get data based on condition; then and else can be driven to view or write out put.