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?
