What are you looking for?

Converting Excel Worksheets to DMN

  • Blog
  • >
  • Converting Excel Worksheets to DMN

Decision Model and Notation (DMN) is the new kid on the block when it comes to defining decisions and business rules. Like BPMN and CMMN, it tries to bridge the gap between human readable definition of business-relevant aspects and technical realization. DMN therefore has a graphical representation as well as an XML-based serialization format and Camunda provides you with a beautiful editor to manage both. So why not go full DMN any minute now? Probably because you work with business rule definitions for much longer than DMN is around and you manage them in Excel. Recreating these with the DMN editor is a tedious task. That is where Camunda’s newest community extension comes into play: The Excel worksheet to DMN converter.

Take an Excel table,

Example Excel table

convert it to DMN,

Example DMN table

and you are one step closer to automating business decisions with Camunda BPM.

How to use

The quickest way to get started is to try the command line tool:

  1. Download the command line tool. It is a runnable jar file, so you need to have Java installed.
  2. Take an Excel file that contains a decision to convert and place it next to the downloaded jar.
  3. Execute java -jar dmn-xlsx-cli-0.1.0.jar --inputs A,B,C --outputs D,E,F path/to/input/file.xlsx path/to/output/file.dmn. Note that this example assumes the columns A, B, and C are inputs and D, E, F are outputs. You can set these as you like.
  4. Obtain the dmn table and import it in Camunda modeler or in the online DMN table editor.

Background

The goal of this project is to provide a Java library for conversion between Excel worksheets and DMN tables. Since no two Excel tables look alike, the library aims for customization of the conversion process. On top of the standalone library, there is a process engine plugin that enables including Excel files in a process application deployment. The files are converted into DMN tables on the fly during deployment. For details, have a look at the GitHub repository.

Contribute

We are eager to receive feedback and improve the library in future versions. Contributions in form of code, bug reports, and feature ideas can be made directly in the camunda-dmn-xlsx repository on GitHub.

Start modelling business process workflows using BPMN

Try All Features of Camunda

Related Content

At CamundaCon 2024 Berlin, MetaOps discussed how they used data-driven insights to transform operational oversight for the UK General Register Office.
Tim Stawowski spoke at CamundaCon 2024 Berlin about how Wergarantie uses Camunda Optimize to measure process and business KPIs.
Deutsche Telekom improves customer engagement with process orchestration and Camunda.