Hi, I am using excel 2000. I've got a lot of problems while parsing the excel files. An exception of type '
Caused by: *java.lang.ArrayIndexOutOfBoundsException * at java.lang.System.arraycopy(*Native Method*) at org.apache.poi.hssf.record.UnknownRecord.<init>(*UnknownRecord.java:62*) ' occurs often when I modify a well formatted excel file. I am looking for a way to avoid these exception. Can I use a newer version of the apache POI ? Thanks, Pascal On 1/14/06, Michael Neale <[EMAIL PROTECTED]> wrote: > > 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 > > > > > >
