Create custom excel import

Question

question

Maria B17 asked Apr 20, '23 Jeanette F commented May 3, '23

Create custom excel import

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.

Software Version:

FlexSim 23.1.1

flexscript development debugging

· 1

Jeanette F ♦♦ commented · May 03, 2023 at 02:27 AM

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.

0 ·

Answer 1 · 2023-04-25T17:17:00Z

anon-user answered Apr 25, '23

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

Answer 2 · 2023-04-20T14:26:41Z

Iago MF answered Apr 20, '23

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!

question