Questions about using flexscript to import excel

[j08j]

[ FlexSim 24.0.2 ]

I want to use flexscript to import the Data.xlsx file into GlobalTable1 according to the settings in the figure below, but it has not been successful.

Where is the problem?

Thanks for the help.

[moehlmann_fe · Accepted solution]

In the command "excelimporttable()" you have to actually specify the start row/column and number of rows/columns to import. The target table also must already have these dimensions as it will not automaically resize to fit the data and the data types of its columns must also match the data in the excel file.

You can also run the import defined in the interface with "excelmultitableimport()".

[j08j]

There are my excel sheets:

I made the following modifications:

but it shows error:

[moehlmann_fe]

Are you trying to read a value from the tables after importing? Because you are not setting their size. Newly created tables will have one row and one column. As I mentioned already, the excelimporttable() command will not adjust their size by itself. Use "Table().setSize()" before you import.

[j08j]

Thanks, it works successfully. But I have a question. If the data in Sheet1 is a different array size every time I inport it, what should I do? Is there any other way besides directly setting a super large size?

[moehlmann_fe]

As mentioned in the answer, you can define the import parameters in the Excel interface and then run that through code (so the range of values and table resizing happen automatically).

Or you read the excel file row by row (excelreadnum(), excelreadstr(), excelreadcell()) as long as there is valid data and add a new row to the table every time.

[j08j]

I'll give it a try, thanks for your help!