How to import multi sheet excel file using Excel importer in Mendix. useful for those still using Mendix lower version for application development.

1

Step1: - Install Excel Importer from the marketplace in your mendix studio pro.

 

Step2: -Create Separate Helper Entity for each sheet of Excel in Domain Model, if want you want to upload data in different entities. Else in same entity you can import data from different sheet.

 

Step3: -Define Template for each sheet. While creating the excel template, define Sheet no., Header row no. and import from row no. correctly.

 

 

Step4: -After define template click on import and select the file which you want to upload and click in import button.

 

Step5: - In import button call a Microflow IVK_ImportTemplateDocument.

 

Step6: - Retrieve activity in the IVK_ImportTemplateDocument, it will retrieve selected Template by association.

 

Step7: -. After completion of Process flow for 1st sheet of Excel import. Call a 2nd Sub microflow2 In Microflow1.

Step8; -In IVK_ImportTemplateDocument2 Retrieve the template required for the 2nd sheet by XPath.

 In IVK_ImportTemplateDocument2 you will load the 2nd sheet data.

In this way you will be able to import the Multi-sheet Excel file and get the data of each sheet.

Posted 2025-04-17

1 comments