topic Re: excelexporttable() exports empty sheet for StatisticsCollector in FlexSim Forum

excelexporttable() exports empty sheet for StatisticsCollector

mail7WJMZ — Thu, 24 Aug 2023 03:03:09 GMT

[ FlexSim 23.2.0 ]

Hello,

Because build-in Excel interface won't clear the sheet before exporting, I tried to use custom export script like this:

string filePath = "D:\\Data.xlsx";
excelopen(filePath);

string sheetName = "Sheet1";
Table table = Table("StatisticsCollector1");
exceldeletesheet(sheetName);
excelcreatesheet(sheetName);
excelsetsheet(sheetName);
excelexporttable(table, 1, 1, table.numRows, table.numCols);

excelsave();
excelclose(0);

But excelexporttable() on StatisticsCollector exports empty sheet.

By the way,

Use build-in Excel interface to export StatisticsCollector has encoding issue, which was fixed for GlobalTable in FlexSim 18.0.7, but not fixed for StatisticsCollector.

Table("StatisticsCollector1").cloneTo("GlobalTable1") throw exception.

Perhaps you could provide an option to let user choose the character encoding?

Re: excelexporttable() exports empty sheet for StatisticsCollector

JordanLJohnson — Wed, 30 Aug 2023 17:24:23 GMT

The excelexporttable() command does not currently support exporting Statistics Collectors or Calculated Tables. I will add a request to the dev list to improve this feature.

The encoding issue is on the dev list already. I will links this report to that issue.

I will also add a report that cloning a stats collector to a global table throws exceptions.

Re: excelexporttable() exports empty sheet for StatisticsCollector

JordanLJohnson — Wed, 30 Aug 2023 17:32:12 GMT

For exporting Statistics Collectors to Excel, you can use the Excel interface. The API could still be improved, however.

Re: excelexporttable() exports empty sheet for StatisticsCollector

borja_lorenzo — Tue, 11 Feb 2025 12:59:04 GMT

The excelexporttable() command directly from a Statistics Collector in version 24.1 still results in an empty table. Is it still not possible? I have reviewed the update notes and found nothing related. I have resolved it by dumping the table from the Statistics Collector into a global table and then applying the command to that global table.