Is it possible to setup arrays in a global table from Excel?

Question

question

Carmen F asked Feb 18, '21 Ryan Clark commented Nov 16, '21

Is it possible to setup arrays in a global table from Excel?

Hello,

I want to setup arrays in a Global Table from an Excel file. Is it possible? I don’t know if it will be the right method but I’m trying to do it by using the Excel import tool in Flexsim directly. Cells in the Global Table has being assigned as Array data but the problem is that I don’t know how values of each array must be written in Excel to being imported in the cell as an array. I only got to import values as strings.

if this is not the appropriate method, what would be the best way?

Thanks in advanced.

Regards.

Software Version:

FlexSim 21.0.2

global table flexsim 21.0.2 data import arrays

Answer 1 · 2021-02-18T14:11:35Z

Roi Sánchez answered Feb 18, '21 Ryan Clark commented Nov 16, '21

Hello @Carmen F, I guess you cannot import arrays natively from Excel.

Despite this, you could import these Arrays from Excel as strings and then run some code in the Post Import Code section of the Excel Importer to convert them automatically to Arrays. I attach you a model with this code that it will work as long as your strings have this format:

{value,value,...}

support-array from Excel.fsm

support-array-from-excel.fsm (26.0 KiB)

· 3

Carmen F commented · Feb 19, 2021 at 06:03 AM

Thank you for your help Roi, it has run perfectly!!

0 ·

Dylan W2 commented · Nov 16, 2021 at 02:55 PM

Hey Roi,

The answer helped me alot so far, I have a question to ask though. Is there a way to import strings into this? I tried some methodes and get stuck over and over again. The array I wanna import looks like this {ABC, 1,5,0}, The output I get is {0,1,5,0}.

Thanks in advanced.

Regards.

0 ·

Ryan Clark Dylan W2 commented · Nov 16, 2021 at 10:08 PM

Hi @Dylan W2,

Could you please ask this question as a separate post?

Please see Best practices for using this Answers site - FlexSim Community for more details. Thanks!

0 ·

question