Checked the web application for the cause of why the blank rows passed into the validation, as per checking, the cause is when the application read the data from the excel, it removes the header and all the blank rows before the data is passed into the validation. Modified the web application, to add the validation for the blank row in between the data.