1

你好

我希望移动机器人能根据外部Excel时间表执行运输任务，该表包含时间戳、起点和目的地。（见下表）

image
图片629×120 2.49 KB

目前，我知道可能有两种方法，但不确定是否可行：

  1. 进料表（CSV）
    将Excel时间表转换为进料CSV。
    每个起点-目的地对都需要单独的产品类型和工艺流程，这导致在我们的案例中大约需要2,000个产品/流程设置，使得这种方法不切实际。
  2. Excel读取器 + 产品属性路由
    使用Excel读取器加载路由数据，将这些值写入产品属性，并让下游流程通过产品属性过滤器路由产品。
    这种方法适用于路由，但似乎无法根据Excel文件中的时间戳触发产品释放。

我想就上述方法征求您的帮助或建议，或者是否有其他解决方案，谢谢。

2

Hi, for the second approach, with the Excel Reader, you can use “SimTime()” to get the actual time and wait until it’s time to create a new product.

One solution would be to use an If-loop in which you check ifTiming <= SimTime()". If yes you can create the product, if not wait 1s for example.

The other solution would be to add a Real-Property to the process to calculate the remaining time before you need to create a new product –>Delay = Timing - SimTime(). And then use a Delay in which you use this property as Expression.

grafik
grafik1370×1252 201 KB

3

You can also try this AddOn, which allows you to read an Excel file directly in a process :VariablesCache + TransportPatternIn helper

4

Hello Tilma

Could you please share this layout? not sure what it needs NextProcess (in Product) and SendSignal (in Process Node).

你好， 我没有保存布局…… 产品属性“NextProcess”只是一个测试，用于通过TransportIn中的属性过滤器将产品传送到正确的机器流程（开始时NextProcess = Start，处理一次后，NextProcess = Destination）。也可以使用“GetFlowStep”和“SetNextFlowStep”语句来调整每个产品的流程。 “SendSignal”语句与ExcelReader配合使用，通过触发信号“TriggerRead”来读取表格的下一行。 Gene 2026年1月28日 上午9:00 你好Tilma， 当我尝试复制你的布局时，过滤器显示了这个错误。你知道为什么吗？ 图片 958×514 75.2 KB Excel Read Test.xlsx (8.7 KB) Excel Reader Test.vcmx (275.9 KB) Tilma

Hello,

I didn’t save the layout…

The product propertyNextProcesswas just a test to transport the product to the correct Machine process using the property filters in TransportIn (NextProcess = Start at the begining, and after having been processed once, NextProcess = Destination). It might also be possible to use theGetFlowStep+SetNextFlowStepstatements to adjust the flow for each product.

The statementSendSignalis used with the ExcelReader to read the next row of the table by triggering the signal “TriggerRead”.

6

Hello Tilma

As I tried to duplicate your layout, it shows this error in the filter. Do you know why it is?

image
image958×514 75.2 KB

Excel Read Test.xlsx(8.7 KB)

Excel Reader Test.vcmx(275.9 KB)

7

The propertyStartis a string, so inComparisonValueyou need to write“A"not justA

8

Thank you, Tilma, now it works.

9

Hello Tilma

I would also like to record the real robot pick time and the product arrival time and export to an excel, so that I can see what’s the delay. Do you know how to do? thanks.