Are the templates all the same? Because then you could write a logic as follows:
- Retrieve Template (with sheet = 1)
- Run template on the excel file
- Changed template (sheet = 2)
- Run template on the excel file
- rinse and repeat, at the end set your template to sheet = 1
Hi Praveen,
https://medium.com/@mohammad.saqib_1262/how-to-import-multiple-excel-sheets-from-a-single-workbook-using-mendix-e203f687b5f7
read this article but you have to make all the templates then you can import all the excel sheet from single workbook with different different templates.