Simple Excel Reading Sim Doesn't Work

Moderator: Moderators

Simple Excel Reading Sim Doesn't Work

Postby john.dufour@raytheon.com » Mon Feb 15, 2021 4:36 pm

Hello!
This is my first post. I'm new to MagicDraw and very motivated to learn it. I have a task to demonstrate the usefulness of MagicDraw. I've created the attached model. It's based off of this youtube video:

https://www.youtube.com/watch?v=kcu3ofPSjqY

I see that my state machine transitions correctly, but I'm not able to verify the Excel read and write operations. I've explored Excel Helper dependencies. I examined MagicDraw's compatibility matrix and did not see any dependencies. According to the matrix, it appears that MagicDraw and the Excel Helper plugin are all that's required. Would you verify this for me please? If there are dependencies, what are they? I noticed in the video that my Containment breakdown does not match the Containment breakdown in the video. The Containment breakdown in the video shows an opaque behavior. I'm not sure how this opaque behavior was established.

Can you tell me why my model runs but does not complete the Excel manipulations?

1,000,000 Thanks!

John
You do not have the required permissions to view the files attached to this post.
john.dufour@raytheon.com
Forum Newbie
Forum Newbie
 
Posts: 2
Posts Rating:0
Joined: Thu Feb 04, 2021 2:30 pm

Re: Simple Excel Reading Sim Doesn't Work

Postby john.dufour@raytheon.com » Wed Feb 17, 2021 8:56 am

Hi!
Instead of attempting to describe what's wrong with my model, I'd be tremendously grateful if someone would post the most simple model that would read an Excel cell value. Any explanation of your model's workings would be very appreciated. I hope to post up a different model for inspection later today.

Very grateful for your assistance!

John
john.dufour@raytheon.com
Forum Newbie
Forum Newbie
 
Posts: 2
Posts Rating:0
Joined: Thu Feb 04, 2021 2:30 pm

Re: Simple Excel Reading Sim Doesn't Work

Postby ogirdor » Fri Feb 26, 2021 4:31 am

Hi John,

as far as I can see, the main problem with your model is that the element where you have put your ExcelHelper code is not an opaque behavior. But still I was not able to successfully interact with the Excel file. I get the error "ERROR: Cannot find '"VLookUpExample.xlsx"' from either the project directory or attached file.". This is the same problem that is commented under the video you linked.

Good luck!
ogirdor
Forum Beginner
Forum Beginner
 
Posts: 35
Posts Rating:11
Joined: Wed Jun 03, 2020 4:41 am

Re: Simple Excel Reading Sim Doesn't Work

Postby saulius_p » Fri Feb 26, 2021 7:24 am

Hello John,

Good to talk to you. Please find attached model. It should work as required. Main problem I see Call Behavior Action used instead Opaque Behavior.

Sincerely,
Saulius

ExcelHelperExample.mdzip
You do not have the required permissions to view the files attached to this post.
Best regards,
Saulius Pavalkis
User avatar
saulius_p
No Magic
No Magic
 
Posts: 278
Posts Rating:11
Joined: Fri Dec 04, 2009 5:37 am
Full name: Saulius Pavalkis


Return to Cameo Simulation Toolkits

Who is online

Users browsing this forum: No registered users and 0 guests