[ FlexSim 20.2.2 ]
I have pasted the results from "Statistics Tables" directly to Excel. I found there are two problems of doing this. First, it takes longer to paste it when the data is large. The second, it can only paste the data within 1,046,697 columns into Excel. Is there a better way to do this? Thanks for your help!
You can try checking the "Save statistics data for each replication" box. This will work if you're using a Statistics Collector by saving the data in the Stats Collector after each replication.
Then, you can set up a trigger on End of Replication to export the Stats Collector. The data will export in CSV format, which should make it easier to import into Excel.
The code used to export a table is just:
exporttable();
Someone may come along with a superior idea, but that's what I have to offer. Feel free to comment back if you run into any issues. Hope this helps!
