I would like to know if anybody has created anything where it allows the user that is uploading the Excel file, to specify the mapping.

As it is, the ExcelToRecord action requires that a Record definition is set. 

However, I have a requirement where users have Excel spreadsheets where the column names could be anything, some may have more columns, some may have fewer.

The uploading happens with some steps -

1. The user uploads the file

2. The application matches as many of the columns on the file that it can to the fields

2. The user maps the columns that was missed by the application

3. They review it, and save it (standard stuff from there on)

Has anybody done anything like this before?

Thanks

Willem