question

mary avatar image
0 Likes"
mary asked Kavika F commented

Excel export interface

How do i export data from global table to excel automatically. whenever i run the model. Please do help

FlexSim 22.0.0
FlexSim 20.0.10
global tableexcel export
· 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

Jeanette F avatar image
0 Likes"
Jeanette F answered Jeanette F commented


Hello @mary,

You can export a global table to excel by using this tool in the tool box.

1653599041902.png


You can also use code to export. You can find more details of how to accomplish this in the manual.

" To execute your custom import or export code through a flexscript node or trigger, call the following: "

  1. treenode excelauto = Model.find("Tools/ExcelAuto");
  2. executefsnode(getvarnode(excelauto, "CustomImport"),NULL);
  3. // or
  4. executefsnode(getvarnode(excelauto, "CustomExport"),NULL);

1653599041902.png (39.3 KiB)
· 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.