Hi Team,
I am importing array data from excel as Array[2]: {Room1, Room2} but it is read as string in assigning label logic.
How can I get it back to array?
Or what is the best way to import such data since user will be interacting from excel only?
Thank you!
If you can't do as Jorg suggest and keep single values in the cells then you can postprocess the import using the string.split() method
Hi @Jason Lightfoot@Joerg Vogel,
I have built my model logic to work for array. So, after importing data in cells, how can I convert that into array for every row in global table?
Thank you!
Table t=Table("GlobalTable1");
for (int n=t.numRows;n>0;n--){ //iterate through the rows
string s=t[n][1]; // row n, column 1
Array sArray=s.split(","); // get the array using comma delimiter
t.cell(n,1).value=sArray.clone(); // overwrite the table cell value
}
If you just have your values comma separated in Excel the above code will convert the column to arrays.
14 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.