How to paste the results from "statistical table" when the data is too large

Question

question

Jun J2 asked Oct 14, '20 tannerp edited Oct 14, '20

How to paste the results from "statistical table" when the data is too large

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!

Software Version:

FlexSim 20.2.2

flexsim 20.2.2 export data

1602710074637.png (65.9 KiB)

1602710245691.png (27.4 KiB)

Answer 1 · 2020-10-14T22:22:26Z

tannerp answered Oct 14, '20 tannerp edited Oct 14, '20

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!

1602714089647.png (36.6 KiB)

1602714131536.png (24.8 KiB)

question