...
unnecessarily requires validation on plugin side. Whereas user can always mention those three fields in "output schema" input field.
D. How will the output schema fields be mapped to the excel column name?
a. Will the field names in the output schema be same as excel column name? If no then, a separate excelColumn-OutputField mapping input will be provided to the user
which will be an optional field. If the user provides mapping for the excel column then that mapped value will be treated as output field otherwise original excel column
names will be used in output record.
b. If the user specified field names in output schema are different than the excel column names or mapped values, a validation error will be thrown.
Assumptions
1. All the excel files/sheet specified should have required output columns otherwise it would be considered as error excel.
...