question

Marc R5 avatar image
0 Likes"
Marc R5 asked José Antonio MD edited

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!

FlexSim 22.1.1
custom codeexcel importparameters
5 |100000

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

1 Answer

José Antonio MD avatar image
0 Likes"
José Antonio MD answered José Antonio MD edited

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

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