EOS Platform7.2导入导出excel时报错：org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.NoSuchMethodError

【问题描述】

EOS Platform7.2导入导出excel时，因poi版本冲突报错：

org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Lorg/apache/poi/hssf/util/Region;)I

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

【解答】

1， 找到应用服务器目录lib下：D:\eos_install\apache-tomcat-7.0.54\webapps\default\WEB-INF\lib；将poi-3.0.2.FINAL.jar替换为poi-3.11-20141221.jar

_

2, 将D:\eos_install\ide\eclipse\dropins\PLATFORM_7.2.0.0\plugins\com.primeton.studio.server.library_7.1.0.0\server\3rd\apache下poi-3.0.2.FINAL.jar替换为poi-3.11-20141221.jar

_

3、项目右键—>属性，更新EOS程序全量库，添加poi-3.11-20141221.jar

_

4、再次编译项目