Is it possible to setup arrays in a global table from Excel?
Version: FlexSim 21.0.2
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?
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:
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.