|
版本: |
BeX5V3.1 |
小版本号: |
|
|
|
数据库: |
Oracle |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 7 |
浏览器: |
Chrome |
|
|
请问在X5中不支持外部jar包么?使用:
外部jar包导入后,存放到HashMap<String,Row>会出现这个异常,为啥?我的action是这么写的:
public static HashMap<String,Row> readExcel(String fileName) {
boolean isE2007 = false; // 判断是否是excel2007格式
if (fileName.endsWith("xlsx"))//判断后缀是否相同
isE2007 = true;
try {
InputStream input = new FileInputStream(fileName); // 建立输入流
Workbook wb = null;
// 根据文件格式(2003或者2007)来初始化
if (isE2007){
wb = new XSSFWorkbook(input);
}else{
wb = new HSSFWorkbook(input);
}
Sheet sheet = wb.getSheetAt(0); // 获得第一个表单
//创建Map
HashMap<String,Row> map = new HashMap<String,Row>();
for(int i = 1;i<=sheet.getLastRowNum();i++){//共4行 长度3
map.put(i+"", sheet.getRow(i));
// System.out.println(sheet.getRow(i));
}
return map;
} catch (Exception ex) {
throw new RuntimeException("ReadExcel Exception:"+ex.getMessage());
}
}
异常信息如下:
com.justep.exception.BusinessException: 编码: JUSTEP150087; 提示: 不支持数据类型"org.apache.poi.hssf.usermodel.HSSFRow@1512a40", class "class org.apache.poi.hssf.usermodel.HSSFRow"
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.transform.ResultTransform.transformByJson(Unknown Source)
at com.justep.system.transform.ResultTransform.transformMapByJson(Unknown Source)
at com.justep.system.transform.ResultTransform.transformCompObjectByJson(Unknown Source)
at com.justep.system.transform.ResultTransform.transformByJson(Unknown Source)
at com.justep.system.transform.ResultTransform.transform(Unknown Source)
at com.justep.system.transform.ResponseTransform.transform(Unknown Source)
at com.justep.system.action.Engine.translateResult(Unknown Source)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
|
|