Read Excel sheet line by line

0
My app needs to import data from an Excel sheet that contains multiple tables (in one sheet). In this case I don’t think I can use the way in the page; https://docs.mendix.com/howto/integration/importing-excel-documents My current idea is to read the Excel sheet line by line with a delimiter. Is it possible to do it in microflow or nanoflow without coding such as Java, and how if yes? Could someone please help me? Thanks & regards, Jun
asked
2 answers
1

Hi Jun

 

Not sure if this helps… 

I assume you have one excel file which has to be distributed to several entities in Mendix.
If so, create new templates(with lots of ‘Not in Use columns’) and change “IVK_ImportTemplateDocument” like below.

 

It completely differs from your idea,,, hope this helps.

Regards,

Yuki

answered
1

Hi Yuki,

It can be a workaround! Thanks a lot!!

Regards,

Jun

answered