How to skip rows and avoid invalid data in Web and Excel Automation

[sathya_auto]

I have Excel file to automate in Web automation…In that Excel file there will be blank cell and invalid data

[lrtetala (Lakshman Reddy)]

Hi @sathya_auto

Try this

String.IsNullOrEmpty(CurrentRow("Column").ToString) OR CurrentRow("Column").ToString.Equals("Invalid Data") OR CurrentRow("Column").ToString.Equals("Invalid Data")

Hope it helps!!

[sathya_auto]

thankyou got it works fine