question

hermione12 avatar image
0 Likes"
hermione12 asked hermione12 commented

Export globaltable to excel on Model RunStop

Hello,

I have doubt regarding exporting global table to excel on Model RunStop. After the model stops at the stop time, should I manually execute the custom code export or will it execute by itself?

FlexSim 20.0.10
globaltableexportexcelrunstop
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 hermione12 commented

The 'OnRunStop' model trigger will fire when the model is stopped at a stop time. If said trigger contains code to export a table to excel then that should execute.

1654595392730.png

If it's not working for you it would be good if you could attach a model.


1654595392730.png (1.8 KiB)
· 3
5 |100000

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

hermione12 avatar image hermione12 commented ·

Sorry for the delay in response. @Felix Möhlmann

Here I have attached the model ,until I click the execute icon from the custom export excel. It does not export. Please help me to solve this issue.

export_excel.fsm

0 Likes 0 ·
export-excel.fsm (40.9 KiB)
Felix Möhlmann avatar image Felix Möhlmann commented ·

You have a small error in the export node path: It should be 'ExcelAuto' instead of 'Excelauto'

1654669416631.png

Furthermore, the first parameter of 'filebrowse' should only contain the file extension (xlsx), not the file name.

1654669472737.png

0 Likes 0 ·
1654669416631.png (7.2 KiB)
1654669472737.png (4.4 KiB)
hermione12 avatar image hermione12 Felix Möhlmann commented ·
Thank you @Felix Möhlmann

Its working

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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