Is there an easy way to write or export data from an ItemList to Excel? I don't see it working using the Export to Excel tool.
Exporting or ODC ItemList to Excel
FlexSim 25.0.2
Hi @Jason Merschat, was Jeanette F's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.
Hello @Jason Merschat,
You can export tables to excel, so if you query the list and clone it to a table then you can export that table.
string directory = modeldir();
string filename = filebrowse("TestBook1.xls","Excel Files",directory);
excelopen(filename);
excelsetsheet("Sheet1");
Table Result = Table.query("SELECT * FROM ItemList1");
Result.cloneTo(Table("GlobalTable1"));
excelexporttable("GlobalTable1",1,1,10,2);
excelclose(1);
10 People are following this question.
