Excel reader

[CiprianRoman]

Hello everyone,
i have a a quiz question:
i have created a simulation for a few workstations along a conveyor.
now, for this one i also have an excel with work times which is provided from Production Preparation.
how can i connect the Excel times with my Workstation’s work times?
perhaps can anyone give me an idea!
Thank you all in advance

[Lefa]

Hi,

There are some older forum threads and an academy tutorial on how to do it with CSV.

Import and Export Data with CSV Files | Visual Components Academy

Excel interface

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…

Importing Excel data to Drive Simulation

①place openpyxl into site-packages folder[Place openpyxl in the site-packages folder] ②Place jdcal.py in the lib folder [Place jdcal.py in the lib folder] ③ The following error occurred at runtime [error code] ④So I downloaded et_xmlfile-1.0.1 again and put et_xmlfile into the site-packages folder [et_xmlfile] The reference aspect is fine, but the runtime error is as follows： from vcScript import * from openpyxl import workbook def OnSignal( signal ): pass def OnRun(): wb=workbook(…

What kind of workflow are you looking for? And what objective do you hope to achieve?

br,
Lefa