question

Patrick Zweekhorst avatar image
0 Likes"
Patrick Zweekhorst asked Matthew Gillespie edited

Is it possible to do excel import in start of replication in experimenter

Hi,

We have a customer that wants only 1 variable in its experimenter.
This variable will be the name of an excel sheet that needs to be imported.
I have set the excel import such that it will look at the correct table.

The problem now is that the file is not imported, and I get some exceptions in the system console of the replication.

exception: Exception Caught in ExcelAuto::updateProgress(string status, double value) object: /Tools/ExcelAuto
exception: Exception Caught in ExcelAuto::importTables(int onreset) object: /Tools/ExcelAuto
exception: Exception Caught in ExcelAuto::doImport() object: /Tools/ExcelAuto
exception: Exception Caught in ObjectFunction99__project_exec_commandlist_excelmultitableimport_node object: MAIN:/project/exec/commandlist/excelmultitableimport/node i: MAIN:/project/exec/commandlist/excelmultitableimport/node class: MAIN:/project/exec/commandlist/excelmultitableimport/node
exception: Exception caught in TreeNode::callMemberFunction() c++/dll execution. Throwing... MAIN:/project/exec/commandlist/excelmultitableimport/node c: MAIN:/project/exec/commandlist/excelmultitableimport/node i: MAIN:/project/exec/commandlist/excelmultitableimport/node thisClass: MAIN:/project/exec/commandlist/excelmultitableimport/node
exception: Exception caught in evaluation of MAIN:/project/exec/commandlist/excelmultitableimport/node

I think the problem is related to the fact that the view tree does not exists in the experimenter.
Is it possible to use the excelmultitableimport command in the start of experiment trigger?
Or are there other suggestions?

Thank you for your time,
Patrick

FlexSim 19.0.7
experimenterexcel importexcelreplicationsstart replication trigger
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered Matthew Gillespie edited

Our connection to excel is only single threaded, so multiple replications of excel can't access a workbook at the same time. Most customers import all the necessary tables before beginning the experiment, and switch based on the current replication number. You could also consider using a database. Most databases are designed to have many readers/writers, so importing during an experiment is very doable.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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