Validate Excel Files

Validates the supplied list of Excel xlsx files according to the supplied reference table structure.

Returns two data outputs. The top output is the list of files that pass validation and the lower output is the files that failed, along with a Collection containing details of the failures.

Input ports

1. Type: Table
   List of Input file paths e.g. from List Files/Folders
   The file list to be processed. That path must be in the column named "path" and be of path datatype
2. Type: Table
   Input Reference table
   Table with the required data structure. This can be, for example, a reference XLSX file, or a Table Creator.

Output ports

1. Type: Table
   Files OK
   The list of files that passed validation
2. Type: Table
   Files Failed
   The list of failures