Eclipse Community Forums: Epsilon » Validating Excel using Epsilon Java API

Help

Home

Home » Modeling » Epsilon » Validating Excel using Epsilon Java API

Show: Today's Messages :: Show Polls :: Message Navigator

Validating Excel using Epsilon Java API [message #1837606]

Wed, 03 February 2021 06:18

Hong Sun

Messages: 4
Registered: February 2021

Junior Member

I am trying to use Epsilon Java API (https://download.eclipse.org/epsilon/2.2/javadoc/index.html) to validate Excel files.
But I could not find an example of this.
Can anyone please show me an example?
Thanks

Report message to a moderator

Re: Validating Excel using Epsilon Java API [message #1837614 is a reply to message #1837606]

Wed, 03 February 2021 08:31

Dimitris Kolovos

Messages: 2165
Registered: July 2009
Location: York, UK

Senior Member

Hi Hong,

Please see [1] for instructions on running Epsilon programs for Java and [2, 3] for examples that show how you can load Excel spreadsheets [4] programmatically. If you have any further questions, please let me know.

Please note that as per [4], there's a regression in the Excel driver in 2.2 so you'll have to use either Epsilon 2.1 or the latest interim version instead.

Thanks,
Dimitris

[1] https://www.eclipse.org/epsilon/doc/articles/run-epsilon-from-java/
[2] https://git.eclipse.org/c/epsilon/org.eclipse.epsilon.git/tree/tests/org.eclipse.epsilon.emc.spreadsheets.test/src/org/eclipse/epsilon/emc/spreadsheets/excel/ExcelModelTest.java
[3] https://git.eclipse.org/c/epsilon/org.eclipse.epsilon.git/tree/tests/org.eclipse.epsilon.emc.spreadsheets.test/src/org/eclipse/epsilon/emc/spreadsheets/excel/ExcelRowTest.java
[4] https://www.eclipse.org/epsilon/doc/articles/excel/

Report message to a moderator

Re: Validating Excel using Epsilon Java API [message #1837647 is a reply to message #1837614]

Wed, 03 February 2021 15:30

Hong Sun

Messages: 4
Registered: February 2021

Junior Member

Thanks Dimitris. Now I can use Java to read the content of Excel.
But I want to validate the Excel using a separate EVL file.
How can I do it?

Report message to a moderator

Re: Validating Excel using Epsilon Java API [message #1837648 is a reply to message #1837647]

Wed, 03 February 2021 15:32

Dimitris Kolovos

Messages: 2165
Registered: July 2009
Location: York, UK

Senior Member

You'll need to replace EolModule with EvlModule in your program and parse your .evl file instead.

Thanks,
Dimitris

Report message to a moderator

Re: Validating Excel using Epsilon Java API [message #1837670 is a reply to message #1837648]

Thu, 04 February 2021 02:34

Hong Sun

Messages: 4
Registered: February 2021

Junior Member

My code is like:
--------------------------------------------
EvlModule module = new EvlModule();
module.parse(new File(PATH_TO_EVL));
module.getContext().getModelRepository().addModel(worksheet.getModel());
module.execute();
---------------------------------------------
Is this correct?

Report message to a moderator

Re: Validating Excel using Epsilon Java API [message #1837684 is a reply to message #1837670]

Thu, 04 February 2021 07:51

Dimitris Kolovos

Messages: 2165
Registered: July 2009
Location: York, UK

Senior Member

This seems to be in the right direction. The argument of addModel should be an ExcelModel and you should have called its load() method before passing it to the EvlModule. Also, after execute() you can access unsatisfied constraints through module.getContext().getUnsatisfiedConstraints().

Thanks,
Dimitris

Report message to a moderator

Re: Validating Excel using Epsilon Java API [message #1837716 is a reply to message #1837684]

Thu, 04 February 2021 14:45

Hong Sun

Messages: 4
Registered: February 2021

Junior Member

Thanks, now I can use EVL to check my Excel file.

One more question:
I see module.execute() returns an object as the result.
But my program gets null.
What result should be returned here?

Report message to a moderator