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. 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? 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~