ExcelRangeRead command

Question

question

asb.p asked May 14 2019 at 5:58 AM Jordan Johnson answered May 15 2019 at 3:59 PM

ExcelRangeRead command

I have been trying to understand the excel read range command i am getting error when i try to run in scrip console.

excelopen("File.xlsx");
excelsetsheet("Sheet1");
treenode myTable = node("Tools/GlobalTables/GlobalTable1>variables/data", model());
excelrangeread(myTable, 1, 1, 0, 0, EXCEL_DATA_AUTOMATIC|EXCEL_USE_COLUMNHEADERS);

The error is in the last command excelrangeread Can any one please let me know what is the error over here.

Software Version:

FlexSim 18.0.10

command helps

Answer 1 · 2019-05-15T15:59:36Z

Jordan Johnson answered May 15 2019 at 3:59 PM

It looks like this command broke when we switched to compiled FlexScript. I'll add a case to the dev list to fix it.

It may be possible to use the dll maker to call this code.

question