Importing array data from excel to global table?

Question

question

Ankur A3 asked Jun 28 2022 at 11:24 AM Jason Lightfoot commented Jun 29 2022 at 8:51 PM

Importing array data from excel to global table?

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!

Software Version:

FlexSim 20.0.10

array excel import

· 1

Answer 1 · 2022-06-28T12:31:21Z

Jason Lightfoot answered Jun 28 2022 at 12:31 PM Jason Lightfoot commented Jun 29 2022 at 8:51 PM

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

· 4

Ankur A3 commented · Jun 28 2022 at 2:22 PM

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!

0 ·

Jason Lightfoot ♦♦ Ankur A3 commented · Jun 28 2022 at 5:10 PM

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.

ConvertTableCellToArray.fsm

0 ·

converttablecelltoarray.fsm (25.4 KiB)

Ankur A3 Jason Lightfoot ♦♦ commented · Jun 29 2022 at 6:18 AM

Hi @Jason Lightfoot ,

I couldn't open this model since I am using version 21.1.5.

Thank you!

0 ·

Show more comments

question