Page 1 of 1

Reading from Excel using Simulation video error

PostPosted: Fri Aug 06, 2021 2:37 pm
by vwaters@mitre.org
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

Re: Reading from Excel using Simulation video error

PostPosted: Tue Aug 17, 2021 10:25 am
by saulius_p
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

Re: Reading from Excel using Simulation video error

PostPosted: Tue Aug 17, 2021 10:28 am
by vwaters@mitre.org
Thank you for clarification. Looks like it might be time to upgrade versions.
Thanks again
Valentina