Continued to check the web application to see where the blank row is removed before it is being passed to the validation, as per checking, the blank row is automatically removed when the data from the excel is extracted and no condition applied to it yet. Checked on what function can be used in the web application to not skip the blank rows between the data.