Question

Import Multiple sheet in same excel workbook - Mendix Excel Importer

0

Hi, I am searching for solution to import multiple excel sheets of the same excel workbook . As of now I can see at a time one excel template imports one sheet at a time. I don't want to create multiple templates(because around 15 sheets are there) and call all templates to import excel workbook. Please help if you know any other alternate solution

asked 2019-02-21

Nirmal Kumar

1 answers

Niels van de Sande · Accepted Answer · 2019-02-21

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