Input getting from excel for DMN

Hi,

I am trying to figure out the way to test DMN file by using test case from excel.
I found following code from github and try to get input from excel and compare result with excel expected result.
Is it possible? Please guide.

Code: GitHub - camunda/camunda-engine-dmn-unittest: Unit test template project for Camunda DMN engine

To the best of my knowledge, there is no build-in functionality for getting DMN test cases from an Excel file. However, you can extend your unit test to

  1. Read and parse an Excel file (for example, using Apache POI)
  2. Run the test for each test case defined in your excel
    An example is described in this blog post https://camunda.com/blog/2016/01/testing-dmn/

Alternatively you may want to checkout the DMN Table Tester described in this post https://camunda.com/blog/2021/02/testing-dmn-tables-automatically/.

I hope that this helps you.

4 Likes