Re: [drools-user] exception in SpreadsheetCompiler().compile(.,.), in 3.0.4, not in

[Michael Neale]

There was a slight format change when moving to 3.0.4 - basically there is an extra row where you can put fact declarations, and put the field constraints in their own cells below (makes it easier to do more complex rules). To have things working basically as before, you need a new row inserted above the "snippets" (like the error message suggests !).

On 10/29/06, Joj <[EMAIL PROTECTED]> wrote:

downloaded jxl-2.6.jar from the url u specified. now, getting this exception
at the same line:

org.drools.decisiontable.parser.DecisionTableParseException: It looks like
you have snippets in the row that is meant for column declarations. Please
insert an additional row before the snippets. Row number: 8
        at org.drools.decisiontable.parser.RuleSheetListener.objectTypeRow(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.processSheet(Unknown
Source) http://www.nabble.com/file/3898/filename1.xls filename1.xls
        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.decisiontable.SpreadsheetCompiler.compile(Unknown Source)
        at
com.stabilix.rule.jbossrule.JbossRuleEngine.getXLSRules (JbossRuleEngine.java:177)


the excel i use is attached.



Geoffrey De Smet-2 wrote:
>
> Are you using maven 2 and got 3.0.4 from the central has repo?
> I had some trouble with transitive dependencies of Drools on the central
> maven repo, such as eclipse-janino etc.
>
> Versions of jxl seem to be on there though:
> http://www.mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl
>
>
> With kind regards,
> Geoffrey De Smet
>
>
> Joj wrote:
>> replaced jars drools-core-3.0.1, drools-decisiontables-3.0.1,
>> drools-jsr94-3.0.1, drools-compiler-3.0.1 by their 3.0.4 versions. now,
>> getting execption on the 2nd line of my function:
>>
>>
>>         //---------function to display excel rules in .drl format--------
>>      public String getXLSRules(String ruleBasePath) {
>>              SpreadsheetCompiler converter = new SpreadsheetCompiler();
>>              String drl = converter.compile(ruleBasePath, InputType.XLS);
>> //--------exception here--------
>>               System.out.println("\n\n" + drl);
>>              return drl;
>>      }
>>
>>
>> the exception is:
>>
>> java.lang.NoClassDefFoundError: jxl/read/biff/BiffException
>>      at org.drools.decisiontable.XlsInput.createParser(Unknown Source)
>>      at
>> org.drools.decisiontable.SpreadsheetCompiler.getRuleSheetListener(Unknown
>> Source)
>>      at org.drools.decisiontable.SpreadsheetCompiler.compile(Unknown Source)
>>      at org.drools.decisiontable.SpreadsheetCompiler.compile(Unknown Source)
>>      at
>> com.stabilix.rule.jbossrule.JbossRuleEngine.getXLSRules (JbossRuleEngine.java:177)
>>
>>
>> plz help A.S.A.P. since this is very urgent.
>>
>> thanx
>> Jojan
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe from this list please visit:
>
>     http://xircles.codehaus.org/manage_email
>
>
>

--
View this message in context: http://www.nabble.com/exception-in-SpreadsheetCompiler%28%29.compile%28.%2C.%29%2C-in-3.0.4%2C-not-in-3.0.1-tf2535631.html#a7065176
Sent from the drools - user mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list please visit:

    http://xircles.codehaus.org/manage_email