Validate and Collect Excel Files

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

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

The third output will (optionally - see config)  return the data rows from all the files that passed validation.

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
3. Type: Table
   Collected Rows
   The rows collected from the valid Excel sheets