Is it possible to use Excel formula and Drools functions in Excel based Decision Table rules ?
Environment
- Red Hat JBoss BRMS (BRMS)
- 6.0.0
Issue
- Is there a feature to use
Excel
(spread sheet) based formulas inExcel
basedDecision Tables
so that the rule engine will be able to usedatediff
or otherExcel
based functions in it's rules? - Is it possible to use
Drools functions
or customJava functions
written in theDrools Model
(e.g.) inside a cell ofExcel
basedDecision Table
rule ? So, it might look like the following to write this value in a cell of theExcel
sheet.
calculateMyPayable(2,125)
Resolution
Excel Sheets
(XLS
files) areDecision Tables
and they are not extensions toDrools
.- The scenario described above can draw multiple use cases as shown below.
1) Using a formula inExcel Sheets
andDrools
uses the value generated by the formula. This option might work and might behave differently based on theExcel
file version. If it does not work a simpleExcel
sheet copy , and paste as values, should generate a workingExcel
sheet.
2) Using a formula inExcel
and Drools uses the value generated by the formula. This will not work, since Drools is not aware ofExcel
formulas , and having a formula contradicts the concept of a decision table.
This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.
Comments