How to check multiple excel file format?

[Anonymous]

Hi,

     I am having excel file format as shown below:

and when file format is wrong like:

If City Code is not present in the file, it should be moved to Error directory. 

My question is how can I handle such situation while working with more than one excel file iteration?

I am having problem with handling more than on excel file format. Similarly, if any of the column from the 4th row is missing or there is not header on the 4th row, the file should move to Error folder.

Thanks,

Dhara

[fdenis]

read your excel as text with header and limit first and last column to get data to check.
then check your rules to valide format.
then of it's the good formant, load them normally.
if not then you can use tWarn to generate error.

[Anonymous]

How can I check  rules to validate file format?