How to import different excel files for different scenarios?

Question

question

David VC asked Dec 18, '18 David VC commented Dec 19, '18

How to import different excel files for different scenarios?

Hi

I am currently struggling to get a grip on how I should import excel files to flexsim for different scenarios.

The problem is as follows: i have a global table: "rack_location" which gives the location of an item on a rack corresponding to its sku-id. Now I need to import different excel sheets for this rack_location globaltable for every different scenario. How should I do this such that I can control which sheet gets read in based on globalvariables defined by the scenario. ( an example of the globalvariable is for example: storage policy. This gives different locations for an sku for every different storage policy. )

Also I have a lot of excel sheets so it would be awesome to make this "automated".

Best regards

David Van Crombrugge

Software Version:

Choose One

experimenter excel import

Answer 1 · 2018-12-18T19:56:34Z

Joshua S answered Dec 18, '18 David VC commented Dec 19, '18

Use this code

excelopen("FileName.xlsx");//ie "C:/Users/user/Documents/Book1.xlsx"
excelsetsheet("Sheet"+numtostring(Sheet));//Global Variable named Sheet 
excelimporttable("GlobalTable1",num_startRow,num_startCol,num_Rows,num_Cols);
excelclose(0);

Replace what you need with your sheet names and global variable names. Your Global Table will need to have the same number of rows and columns as your sheets for it to import correctly with this method.

· 3

David VC commented · Dec 19, 2018 at 09:03 AM

Hey @Joshua S

Many thanks!!! Where do I need to place this code to make sure my globaltables are adapted before the actual simulation run when a new scenario in the experimenter is started?

Best regards

0 ·

Joshua S David VC commented · Dec 19, 2018 at 05:03 PM

I would put it on a model reset trigger.

0 ·

pic1.png (57.5 KiB)

David VC commented · Dec 19, 2018 at 06:06 PM

Thanks a lot!

0 ·

question