Excel interface

General Questions
1

Hi,

I would like to use Excel sheet as a simulation interface to introduce all the simulation parameters, I saw in the forum that we can create CSV files and import them into Visual Component, but this is not what I would like to do. The simulation interface on Excel would have a tab for each machine with parameters like Setup Time, machining Time, TransportIn, TransportOut, … and using a button on Excel, it pushes the values to the right variables. Also, I would like to read values from Visual component to Excel, This will help developing Dashboards displaying any information.

I know that everything could be done by programming, but I am looking for a simple way to open excel, fill a few cells with values and variable names, press a button to push values to simulation and press another button to get values from simulation.

Best regards

2

Check the Excel Reader component from the eCatalog Misc folder. It probably cannot do everything, but it’s a good starting point.

3

VC doesn’t have any external API that would allow you to command it from another program such as Excel. It would be possible for you to develop such API using a .NET add-on, but it is much easier and better overall to just import and export data from within VC instead of trying to use something like Excel to control VC.