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: [email protected] [[email protected]]
On Behalf Of Swindells, Thomas [[email protected]]
Sent: Thursday, October 01, 2009 5:33 PM
To: [email protected]
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
[email protected] 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
[email protected]
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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________
rules-users mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-users
