Drools的决策表xls文件转drl文件所依赖的poi版本

1.最近的项目中使用到了Drools作为规则引擎，今天在开发决策表的导入功能时（xls文件转drl），网上提供的简要例子始终通不过，报找不到类的错误：

示例如下：

try {    ruleTableConvertDRL("D:\\calculation.xls");} catch (IOException e) {    e.printStackTrace();}

/** * 将xls决策表解析为普通规则文件 * @throws IOException */public File ruleTableConvertDRL(String ruleTablePath) throws IOException {    SpreadsheetCompiler compiler = new SpreadsheetCompiler();    File inFile = new File(ruleTablePath);    File outFile = new File("D:\\outFile.txt");    InputStream xlsStream = null;    OutputStream fos = null;    OutputStreamWriter osw = null;    BufferedWriter out = null;    try {        xlsStream = new FileInputStream(inFile);        fos = new FileOutputStream(outFile);        osw = new OutputStreamWriter(fos);        out = new BufferedWriter(osw);        String strRule = compiler.compile(xlsStream, InputType.XLS);        out.write(strRule);        out.flush();        System.out.println("\n" + strRule);    } catch (IOException e) {        throw new IOException("没找到文件或写入文件错误");    }finally{        xlsStream.close();        fos.close();        osw.close();        out.close();    }    return outFile;}

2.报错如下：

org.springframework.web.util.NestedServletException: Handler dispatch failed; nested exception is java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Workbook.close()Vat org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:982)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

Caused by: java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Workbook.close()Vat org.drools.decisiontable.parser.xls.ExcelParser.parseWorkbook(ExcelParser.java:124)at org.drools.decisiontable.parser.xls.ExcelParser.parseFile(ExcelParser.java:83)at org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:103)at org.drools.decisiontable.SpreadsheetCompiler.compile(SpreadsheetCompiler.java:76)

3.首先我的第一反应就是应该是jar包冲突，我当时用的drools版本是6.4，poi是3.9：

4.后来经过多次尝试，选择drools为7.0版本，poi为3.15版本时，测试通过，后台可以正常输出决策表内容

5.drools和poi版本如下：

<dependency>   <groupId>org.kie</groupId>   <artifactId>kie-api</artifactId>   <version>7.0.0.Final</version></dependency><dependency>   <groupId>org.drools</groupId>   <artifactId>drools-core</artifactId>   <version>7.0.0.Final</version></dependency><dependency>   <groupId>org.drools</groupId>   <artifactId>drools-compiler</artifactId>   <version>7.0.0.Final</version></dependency><dependency>   <groupId>org.drools</groupId>   <artifactId>drools-decisiontables</artifactId>   <version>7.0.0.Final</version></dependency><dependency>   <groupId>org.drools</groupId>   <artifactId>drools-templates</artifactId>   <version>7.0.0.Final</version></dependency>

<!-- apahce poi --><dependency>   <groupId>org.apache.poi</groupId>   <artifactId>poi</artifactId>   <version>3.15</version></dependency><dependency>   <groupId>org.apache.poi</groupId>   <artifactId>poi-ooxml</artifactId>   <version>3.15</version></dependency><dependency>   <groupId>org.apache.poi</groupId>   <artifactId>poi-ooxml-schemas</artifactId>   <version>3.15</version></dependency>