I would like to do a custom import from an excel, where in each sheet I will have data placed in the same structure, but with different values.
I would like to import this data into flexsim and have each sheet in my excel generate a global table for me and that its content be the content of the rows and columns of each sheet in my excel.
I'm developing this in flex script, could you tell me the best way? I couldn't find many materials about reading excel on the site or on the forum.
Hi @Maria B17, was one of Vinicius C9's or Iago MF's answers helpful? If so, please click the "Accept" button at the bottom of the one that best answers your question. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.
You can import multiple worksheets using the "Excel Interface" tool in FlexSim
At the top of FlexSim is an Excel logo
Click on it to open
Click on import and "+".
On the right side of the Excel Interface window you have all the settings, but the main ones are:
Import - Put the name of your import
Excel Workbook - You will insert the path to the Excel file
Excel Sheet Name - Name of the sheet in your file
Table data - the table where the data from your sheet will be. For your case, a global table that you create. You must create the Global Table first to make the reference.
Import Tables - Will complete the import process into the Global Table
for more information about Excel Interface: https://docs.flexsim.com/en/23.1/Reference/Tools/ExcelInterface/ExcelInterface.html
Hi Maria!
Here you have the documentation about connectivity with Excel (Import/Export):
https://docs.flexsim.com/en/23.1/Reference/Tools/ExcelInterface/ExcelInterface.html
You can define various settings in the import tab to meet the requirements you mention.
I hope it helps you!
17 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.
