I can see that the OOTB activity MSOParseExcelFile uses java step to parse the content and the code is written to take care of the validation of the template as well.

This is a final activity, so you cant modify it. But you can create your activity on the same line and try to modify the java to address data validation . Just a thought.