question

Marc R5 avatar image
0 Likes"
Marc R5 asked Marc R5 commented

execute code after excel import - onmodelreset

Hello,

I have code on my model reset, that includes an excel import code, and then modifying the import data or adding columns. This should execute only after the excel import is done.

How is it possible to do so?

Thanks!

FlexSim 22.1.1
custom codeexcel import
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

·
Marcello Rosadini avatar image
0 Likes"
Marcello Rosadini answered Marc R5 commented

Hi Marc,

you could place the reformatting code in the PostImport code window.

1650450447051.png


1650450447051.png (69.5 KiB)
· 3
5 |100000

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

Marc R5 avatar image Marc R5 commented ·
Any way to be able to do it wherever I need it? not just here?
0 Likes 0 ·
Jason Lightfoot avatar image Jason Lightfoot ♦ Marc R5 commented ·

"This should execute only after the excel import is done." ?

0 Likes 0 ·
Marc R5 avatar image Marc R5 Jason Lightfoot ♦ commented ·
Yes, it is like this. But there are more logic applied in other places, such as on set parameters, etc. That's why I am asking.

And besides that, I understand Marcello's option, but this will imply to duplicate logic in a other places and I am trying to keep it simple.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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