question

Stanly avatar image
0 Likes"
Stanly asked Logan Gold commented

Export machine status to excel

is it possible to export your machine status to an excell workbook in real time?

FlexSim 24.2.2
excel exportrealtime data
· 1
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

Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered Felix Möhlmann commented Best Answer

You can export data to an (unopened) excel file at any point during the model run. You could for example use the following code in the On State Change trigger of a fixed resouce.

  1. excelopen("C:/Users/felix/Downloads/export-test.xlsx");
  2. excelsetsheet("States");
  3. excelwritestr(1, 2, current.as(Object).stats.state().getCategoryName(toState));
  4. excelclose(1);
· 4
5 |100000

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