Converting Excel Worksheets to DMN

By
  • Blog
  • >
  • Converting Excel Worksheets to DMN
TOPICS

30 Day Free Trial

Bring together legacy systems, RPA bots, microservices and more with Camunda

Sign Up for Camunda Content

Get the latest on Camunda features, events, top trends, and more.

TRENDING CONTENT

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

We're streamlining Camunda product APIs, working towards a single REST API for many components, simplifying the learning curve and making installation easier.
Learn about our approach to migration from Camunda 7 to Camunda 8, and how we can help you achieve it as quickly and effectively as possible.
We've been working hard to reduce the job activation latency in Zeebe. Read on to take a peek under the hood at how we went about it and then verified success.