topic Re: Create custom excel import in FlexSim Forum

Create custom excel import

maria_b17 — Thu, 20 Apr 2023 13:15:22 GMT

[ FlexSim 23.1.1 ]

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.

Re: Create custom excel import

iago_mf — Thu, 20 Apr 2023 14:26:41 GMT

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!

Re: Create custom excel import

__ANON_USER__1 — Tue, 25 Apr 2023 17:17:00 GMT

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

Re: Create custom excel import

Jeanette_Fullmer — Wed, 03 May 2023 02:27:25 GMT

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.