I have a very weird situation . I have a Excel file with data like
Header data_xyz
A|B|C
datA 1|2|3
datB 1|2|3
datC 1|2|3
.
.
.
.
END of Pattern
Recurring Pattern
Header data_xyz
A|B|C
datA 1|2|3
datB 1|2|3
datC 1|2|3
.
.
.
.
END of Pattern
Now we need to validate the data in columns A,B,C is Numeric and similarly check the datA,datB be not empty .
Rules will be 1)No of data rows in pattern differ 2)Each Pattern is defined so any data other than pattern will be invaid
Can we use some design to achieve the same .
Thanks in advance
Aucun commentaire:
Enregistrer un commentaire