Export globaltable to excel on Model RunStop

Question

question

hermione12 asked Jun 7, '22 hermione12 commented Jun 10, '22

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?

Software Version:

FlexSim 20.0.10

globaltable exportexcel runstop

5 |100000

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

Answer 1 · 2022-06-07T09:50:50Z

Felix Möhlmann answered Jun 7, '22 hermione12 commented Jun 10, '22

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.

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

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

hermione12 commented · Jun 08, 2022 at 03:23 AM

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 ·

export-excel.fsm (40.9 KiB)

Felix Möhlmann commented · Jun 08, 2022 at 06:25 AM

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

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

0 ·

1654669416631.png (7.2 KiB)

1654669472737.png (4.4 KiB)

hermione12 Felix Möhlmann commented · Jun 10, 2022 at 03:05 AM

Thank you @Felix Möhlmann

Its working

0 ·

question