Inside the Read Excel Spreadsheet Utilities plug-in, there is a smart service (a

I've attached four files. An xsd that defines my CDT and three example spreadsheets:
Works_no_problem.xlsx contains the correct column headers and no extraneous columns.
might_work_with_header_list.xlsx contains the correct columns but has different headers.
might_work_has_extra_columns.xlsx contains the correct data but has both different column headers and extraneous columns that should be ignored.

I did read the documentation, however there are two smart services, Parse Excel Spreadsheet to CDT, and Parse Excel Spreadsheet to CDT with Header List. The second formed the basis for my question, I'm not sure how to format that Header List input. Is it a data dictionary that allows me to map cdt values to particular headers in the spreadsheet, is it a text array of headers that should map to the cdt values? There isn't much documentation.

Part of the exercise we're trying to build is to use an automated process to capture archival data that's held in spreadsheets, so this tool would be hugely useful for us....

Cheers

might_work_has_extra_columns.xlsx

might_work_with_header_list.xlsx

Works_no_problem.xlsx

Example.xsd

I've attached four files. An xsd that defines my CDT and three example spreadsheets:
Works_no_problem.xlsx contains the correct column headers and no extraneous columns.
might_work_with_header_list.xlsx contains the correct columns but has different headers.
might_work_has_extra_columns.xlsx contains the correct data but has both different column headers and extraneous columns that should be ignored.

I did read the documentation, however there are two smart services, Parse Excel Spreadsheet to CDT, and Parse Excel Spreadsheet to CDT with Header List. The second formed the basis for my question, I'm not sure how to format that Header List input. Is it a data dictionary that allows me to map cdt values to particular headers in the spreadsheet, is it a text array of headers that should map to the cdt values? There isn't much documentation.

Part of the exercise we're trying to build is to use an automated process to capture archival data that's held in spreadsheets, so this tool would be hugely useful for us....

Cheers

might_work_has_extra_columns.xlsx

might_work_with_header_list.xlsx

Works_no_problem.xlsx

Example.xsd