Reading from Excel using Simulation video error

Moderator: Moderators

Reading from Excel using Simulation video error

Postby vwaters@mitre.org » Fri Aug 06, 2021 2:37 pm

Hello,

I recently watched and tried replicating steps outlined in the "Read from Excel using Simulation" video (without creating a Mapping Class as mentioned in Excel Helper APIs page).

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

I am using 19.0 version and I keep on getting an error during run time

00:00:03,936 ERROR: Cannot evaluate Opaque Action: org.mozilla.javascript.EcmaError: TypeError: Cannot call method "size" of null (<Unknown source>#2) in <Unknown source> at line number 2 expression body: csv = ExcelHelper.readObjectsFromSpreadSheet("RPM values.csv", ",", "RPM_mapping"); size=csv.size();

As well as an error referring to "IncludeCustomTypesofRowType" property after downloading the sample model. (screen shot attached).

Please advise how to resolve this.

Thanks
Valentina
You do not have the required permissions to view the files attached to this post.
vwaters@mitre.org
Forum Newbie
Forum Newbie
 
Posts: 3
Posts Rating:0
Joined: Mon Jun 07, 2021 7:46 am

Re: Reading from Excel using Simulation video error

Postby saulius_p » Tue Aug 17, 2021 10:25 am

Hello,

Good to talk to you! Sorry for the confusion, this method is suitable starting v2021x

For v19.0 please use this method - https://youtu.be/kcu3ofPSjqY

Note that you need to download and install no cost Excel Import plugin which you can get from nomagic.com.

Sample is available in video description.

Let us know if issue still persist.

Sincerely,
Saulius
Best regards,
Saulius Pavalkis
User avatar
saulius_p
No Magic
No Magic
 
Posts: 345
Posts Rating:17
Joined: Fri Dec 04, 2009 5:37 am
Full name: Saulius Pavalkis

Re: Reading from Excel using Simulation video error

Postby vwaters@mitre.org » Tue Aug 17, 2021 10:28 am

Thank you for clarification. Looks like it might be time to upgrade versions.
Thanks again
Valentina
vwaters@mitre.org
Forum Newbie
Forum Newbie
 
Posts: 3
Posts Rating:0
Joined: Mon Jun 07, 2021 7:46 am


Return to Cameo Simulation Toolkits

Who is online

Users browsing this forum: No registered users and 0 guests