Yash,
The following approach should work :
DecisionTableConfiguration dtconf =
KnowledgeBuilderFactory.newDecisionTableConfiguration();
dtconf.setInputType( DecisionTableInputType.XLS );
dtconf.setWorksheetName( "Tables" ); // Sheet containing the decision
table
kbuilder.add(ResourceFactory.newFileResource(
"<path to file>\\ExamplePolicyPricing.xls"), ResourceType.DTABLE,
dtconf);
Vijay
yash kapoor wrote:
Hi All, I want to execute the example PricingRuleDTExample.java
contains in drools-examples-drl-4.0.x
This file read the the ExamplePolicyPricing.xls file ,when I am running
it
gives the following error
Exception in thread "main" java.lang.RuntimeException: Script template is
null - check for missing script definition.
at org.drools.decisiontable.model.SnippetBuilder.build(Unknown Source)
at org.drools.decisiontable.parser.ActionType.getSnippet(Unknown Source)
at
org.drools.decisiontable.parser.RuleSheetListener.createCondition(Unknown
Source)
at org.drools.decisiontable.parser.RuleSheetListener.nextRule(Unknown
Source)
at
org.drools.decisiontable.parser.RuleSheetListener.processRuleCell(Unknown
Source)
at org.drools.decisiontable.parser.RuleSheetListener.newCell(Unknown
Source)
at org.drools.decisiontable.parser.xls.ExcelParser.handleText(Unknown
Source)
at org.drools.decisiontable.parser.xls.ExcelParser.processRecord(Unknown
Source)
at
org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:136)
at
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:170)
at
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:101)
at org.drools.decisiontable.parser.xls.ExcelParser.parseFile(Unknown
Source)
at
org.drools.decisiontable.SpreadsheetCompiler.getRuleSheetListener(Unknown
Source)
at org.drools.decisiontable.SpreadsheetCompiler.compile(Unknown Source)
at
org.drools.examples.PricingRuleDTExample.executeExample(PricingRuleDTExample.java:40)
at
org.drools.examples.PricingRuleDTExample.main(PricingRuleDTExample.java:29)
I do not know .....what is wrong in XLS file here I am attaching the code
in
zip format .
Any suggestion/comment will appreciated.
Regards
Yash
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
View this message in context:
http://www.nabble.com/Need-Help-tp21726378p21765197.html
Sent from the drools - user mailing list archive at
Nabble.com.