Unable to import Excel which is exported by other Flexsim model.

Question

question

Vinay S asked May 9, '23 Jeanette F commented May 15, '23

Unable to import Excel which is exported by other Flexsim model.

Hi there,

I'm getting below error, when I exported a excel file from Flexsim model, and trying to import that excel in other Flexsim model. But Excel import function works for other excel files like SAP exported excel files.

The Error message:

exception: Exception Caught in ExcelAuto::importTables(int onreset) object: /Tools/ExcelAuto

exception: Exception Caught in ExcelAuto::doImport() object: /Tools/ExcelAuto

exception: Exception Caught in ObjectFunction100__project_exec_commandlist_excelmultitableimport_node object: MAIN:/project/exec/commandlist/excelmultitableimport/node i: MAIN:/project/exec/commandlist/excelmultitableimport/node class: MAIN:/project/exec/commandlist/excelmultitableimport/node

exception: Exception caught in TreeNode::callMemberFunction() main function. Throwing...

exception: Exception caught in evaluation of MAIN:/project/exec/commandlist/excelmultitableimport/node

Software Version:

FlexSim 23.0.0

excel import

1683629912325.png (92.9 KiB)

· 5

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot ♦♦ commented · May 09, 2023 at 12:20 PM

Are you able to upload your model and workbook?

0 ·

Joerg Vogel commented · May 09, 2023 at 01:35 PM

@Shibananda C2, is the excel file closed by the other FlexSim instance? If a different process has still privileges to an opened file, you do not get access to it. You can create a copy and work with it.

0 ·

Vinay S Joerg Vogel commented · May 10, 2023 at 12:35 AM

I restarted my PC and tried to import, still I'm getting same error.

In windows I enabled show hidden files option, to check when the excel file will open.

(When excel file is opened a temp file with same file name will create, I was observing during this during Flexsim import). And also tried by enabling and disabling DDE (When other applications use Dynamic Data Exchange) option in excel file.

One more thing I observed, after when Flexsim try to import these excel (only Flexsim exported excel file), If I try to open excel it shows blue blank screen. It seems like there is aproblem with Flexsim exported excel.

0 ·

Jeanette F ♦♦ commented · May 10, 2023 at 03:08 AM

Hello @Shibananda C2,

I am not able to replicate your issue. I created a sample model where a processor records to a global table when an item enters the processor. The information written to the global table is formatted so that it could be used in a source. I exported this data and then imported it to a schedule source.

ExportAndImportTest.fsm

TestExportANDImport.xlsx

If you cannot provide your original model and excel file that you are having issues with can you try replicating your issue in another model? It might even be helpful to try out my model by clearing the source and excel file and then see if you can export and import without issue.

0 ·

exportandimporttest.fsm (34.6 KiB)

Jeanette F ♦♦ commented · May 15, 2023 at 02:47 PM

Hi @Shibananda C2,

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