no there is no caching. What version of excel are you using? I have added CSV support as it is less prone to strange variances in the file format which xls is. Unfortunately Excel 97 format is very much a closed format, so it can be a little hard to account for all versions saveing in strange states.
Hopefully Microsoft will open up the new OfficeXML format enough, and that coupled with ODF (OpenDocument) will provide a better general purpose format (but it will take time to be widely available). On 1/14/06, Pascal Chanteux <[EMAIL PROTECTED]> wrote: > > Hi , > > Is there any form of caching during the parsing/loading of an excel > worksheet ? > I have an excel worksheet for my drools test. The result of my test case > is > correct. Everything is OK. > When I change something in the content of my cell, I have this exception : > > *org.drools.decisiontable.parser.DecisionTableParseException: An error > occurred processing the decision table. > at org.drools.decisiontable.DecisionTableLoader.loadDRLFromStream( > DecisionTableLoader.java:124) > at org.drools.decisiontable.DecisionTableLoader.getReader( > DecisionTableLoader.java:108) > at org.drools.decisiontable.DecisionTableLoader.loadFromInputStream( > DecisionTableLoader.java:102) > .......Caused by: org.apache.poi.hssf.record.RecordFormatException: Unable > to construct record instance, the following exception occured: null > at org.apache.poi.hssf.record.RecordFactory.createRecord( > RecordFactory.java > :237) > at > org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents > (HSSFEventFactory.java:183) > at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents( > HSSFEventFactory.java:101) > at org.drools.decisiontable.parser.xls.ExcelParser.parseFile( > ExcelParser.java:263) > at org.drools.decisiontable.SpreadsheetDRLConverter.getRuleSheetListener( > SpreadsheetDRLConverter.java:123) > at org.drools.decisiontable.SpreadsheetDRLConverter.convertToDRL( > SpreadsheetDRLConverter.java:72) > at org.drools.decisiontable.DecisionTableLoader.loadDRLFromStream( > DecisionTableLoader.java:118) > ... 20 more* > > I found a workarround for this, simply by changing the name of the ruleset > in the worksheet. In this case everything works fine again. > > Is this normal or I am missing something ? > > Thanks, > > Pascal > >
