Re: [rules-users] Multiple worksheet decision tables
Hi,
I had written some code for this a while ago. But, basically Drools uses jxl for
compiling decision tables.
You can also use JXL. It has an API that gives you all the worksheet names, which you can
then pass to the compiler one by one to compile all your decision tables.
From memory it went something like this (Import jxl***.jar)
Worksheet w=new WorkSheer(new File("filepath.xls"));
w.getSheets();
This should get you a list of sheets.
Cheers,
Vikrant
________________________________________
From: rules-users-bounces(a)lists.jboss.org [rules-users-bounces(a)lists.jboss.org] On Behalf
Of Swindells, Thomas [TSwindells(a)nds.com]
Sent: Thursday, October 01, 2009 5:33 PM
To: rules-users(a)lists.jboss.org
Subject: [rules-users] Multiple worksheet decision tables
Is it possible to get Drools to load all the rules table within an excel spreadsheet if
they are spread across multiple worksheets?
From the documentation I have read it appears drools will only load
the rules from the first/a specified worksheet.
The only way I have found to do it is to load the worksheet multiple times and
explicitly state each of the worksheet names in turn. Is this the only way?
If so is there any easy way to get the names of all the worksheets in the file? The
application won't know the worksheet names ahead of time.
Many thanks,
Thomas
**************************************************************************************
This message is confidential and intended only for the addressee. If you have received
this message in error, please immediately notify the postmaster(a)nds.com and delete it from
your system as well as any copies. The content of e-mails as well as traffic data may be
monitored by NDS for employment and security purposes. To protect the environment please
do not print this e-mail unless necessary.
NDS Limited. Registered Office: One London Road, Staines, Middlesex, TW18 4EX, United
Kingdom. A company registered in England and Wales. Registered no. 3080780. VAT no. GB 603
8808 40-00
**************************************************************************************
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
MASTEK LTD.
Mastek is in NASSCOM's 'India Top 20' Software Service Exporters List.
In the US, we're called MAJESCOMASTEK
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions expressed in this e-mail are those of the individual and not that of Mastek
Limited, unless specifically indicated to that effect. Mastek Limited does not accept any
responsibility or liability for it. This e-mail and attachments (if any) transmitted with
it are confidential and/or privileged and solely for the use of the intended person or
entity to which it is addressed. Any review, re-transmission, dissemination or other use
of or taking of any action in reliance upon this information by persons or entities other
than the intended recipient is prohibited. This e-mail and its attachments have been
scanned for the presence of computer viruses. It is the responsibility of the recipient to
run the virus check on e-mails and attachments before opening them. If you have received
this e-mail in error, kindly delete this e-mail from desktop and server.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~