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?