Skip to content

Latest commit

 

History

History

dmn-excel-tester

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 
 
 
 
 

Test DMN Tables with data from Excel

With this tool you test your DMN decision table against the data from an Excel sheet.

DMN table

The Excel sheet has to be structured like the decision table: A Header line contains the input and output names from the decision tables. The output names must be preceded with Expected:

Excel example

You can open the User Interface of the DMN Evaluator by double-clicking the dmn-evaluator.jar and upload the DMN table and the excel sheet to evaluate the decisions with the given values. Inspect the results:

DMN evaluator

For background testing you can run the java program com.camunda.consulting.dmn_excel_tester.DmnExcelTester with the filenames of the dmn table and the excel sheet from the console and check the outputs for the result.

Console output

Build and run

Run mvn clean compile test assembly:single to create a single jar.

You can ignore the warning from the maven build, as the project only delivers a single jar file and nothing else.

Start the evaluation with java -jar target\dmn-evaluator.jar dmnFile excelFile.

Prerequistites

This need at least Java 8 to build and run.