Import lines from an excel file according to the model runtime

Question

question

lucas-t asked Feb 9, '23 Jeanette F commented Feb 22, '23

Import lines from an excel file according to the model runtime

I have a very large excel file, and FlexSim crashes when trying to import it all at once, even after doing data cleaning and separating it into 12 different files. So, I would like to import it into FlexSim as needed by the model, for example, every 1 hour of running the model, 10000 rows are imported. I started using FlexSim recently, and I don't know if the best way to solve this problem is with FlexScript in the 'Custom Code' option, or if I should integrate my FlexSim with FlexSimPy. Could someone help me?

Software Version:

FlexSim 23.0.3

excel import python large file

· 4

Jordan Johnson ♦♦ commented · Feb 09, 2023 at 09:29 PM

I don't know that there is a limit on the size of Excel file. How big is the file? Also, what is the "Data Distinction" method set to? The best mode for large files is Values Only (very fast). Does that mode still crash for you?

0 ·

lucas-t Jordan Johnson ♦♦ commented · Feb 16, 2023 at 08:33 PM

Thank you for the answer, and I’m sorry for being late. My Excel File has 1656243 lines, and with the “Values Only” mode all the lines are imported, but after the FlexSim model crashes in the same way, and I can’t move the objects in the model. I would like to know how to use the ‘excelmultitableimport()’ or another function that allow me to import lines according to the model runtime. For example, it would be interesting if the model read a limited amount of rows and then run the simulation, and after that read another amount of rows and run the simulation, and so on until all rows are read. As I said before, I am new to FlexSim, and an example using FlexScript would help me a lot. Thank you very much!

0 ·

Jason Lightfoot ♦ lucas-t commented · Feb 17, 2023 at 06:55 AM

Can you post the excel file? It would be good to know why it crashes.

Have you tried making the table a bundle type? It will use less memory and be faster to access.

0 ·

Jeanette F ♦♦ commented · Feb 22, 2023 at 06:28 PM

Hi @lucas-t,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 ·

question