Dynamic Excel validation

I have some 100 excel files at once in a folder and I need to get the column values (from row 6) to be checked with its header (from row 2 to 4) where the header contains whether that column needs a value mandatorily or not, it is string or decimal or integer or date or it meets the required length given in concatenation with the data type. All this to be done dynamically in KNIME. Can someone suggest workflow.