Hi,

So basically you are trying to say that there will be 2 different excel. From first excel you will just fetch the name of columns and from second excel you will fetch the actual data. Is it the case ? What is the exact use case?

Regards

Let's take an example, as you mentioned there are 4 columns in excel : "Name", "Email", "Phone Number", and "Address" 

So while uploading data from excel, you should map excel to aggregate directly or can create a structure of same datatype of mapping purpose only.

After that inside loop you can write the logic and other validations if required to check the data. Here you can also write the logic to change the mapping like Name column of excel can assign to "Address" column of aggregate.

If format of excel is entirely different than structure entity than ExcelToRecordList method will fail and if any exception occur it will throw exception. But if any exception don't occur then you can check the size of RecordList. If size is zero means either blank excel is upload or format is not correct. So here you simply can show the message "upload valid excel in right format with data".

If RecordList size is more than 0, then you can execute the loop to check the validation for each field if required. Like in loop can check that entered email is a valid email address or not. Phone number is a valid phone number or not. If not valid then can skip that row to process or can skip entire excel as per your business logic.

Once you validate the excel for all inputs and its valid according to your business logic then at last you can process this data to insert in database.