Use parameter to decide when to import from excel

Question

question

Marc R5 asked Apr 20, '22 José Antonio MD edited Apr 20, '22

Use parameter to decide when to import from excel

Hello,

I am dealing with a model, meanwhile we are creating a custom db to import the data.

To make tests I use also an excel model to import data.

For the db import, I create a parameter and a custom code so I can decide if I import from the db or not, with a simple conditional.

Is something similar for the excel import?

I see that in the excel import/export menu there is a post import code option, but I would like to be able to do it in custom codes and using parameter, specially for the import decision.

Thanks!

Software Version:

FlexSim 22.1.1

custom code excel import parameters

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2022-04-20T10:04:31Z

José Antonio MD answered Apr 20, '22 José Antonio MD edited Apr 20, '22

Hello @Marc R5,

You can use a parameter condition (f.ex.: if....else...) and if the condition is tue,use the following code to import excel files:

excelmultitableimport()

I hope I have been helpful.

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question