Excel Import with Custom Logic

Team, We have requirement to provide excel import option to end-users and so we need to have custom logic for records-validation/processing records before it gets saved into DB. I understood Mendix provides Excel Importer plugin, which more works based on template(first template should be created and post-which template should be selected for uploading excel and directly loads records into DB). This might not be useful in my use-case. Could you pls share your thoughts on any approach, that can work here. Appreciate inputs..!   Thanks.!
1 answers

The Excel Importer includes functionality to add custom microflows for data processing. It uses the MxModelreflection to allow you to select a microflow for processing when you create a new template. You can set a different microflow for each column in your sheet: