I don't know whether this applies here, but I quote a comment from
Michael Kay (posted today on another list):
"... the other problem is that in the XML output from Excel, empty
cells are often omitted, their presence signalled only by the
existence of an attribute on the next Cell element that indicates what
column number it is in. This makes processing the XML quite
challenging."
If the XMLs from Excel and OpenOffice differ in that respect, then
this could be a pointer for fixing the problem in Drools.
Michael Kay also mentions the possibility of unifying the Cell
elements so all have the column attribute using a simple XSLT
transformation. (I guess I could provide that, if necessary.)
-W
On Tue, Apr 27, 2010 at 10:57 AM, murphy <christian.niehues(a)its-telco.de> wrote:
It seems that Excel save the files in a format that will be parsed by the
JExcelApi in a wrong way.
So I tried to save the file with Openoffice and it worked well.
So what's the solution for Excel? I tried Excel'97 format but that didn't
help.
--
View this message in context:
http://drools-java-rules-engine.46999.n3.nabble.com/Strange-ArrayIndexOut...
Sent from the Drools - User mailing list archive at
Nabble.com.
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users