x5.2.5报表导出excel会卡死

znbyjn · 发表于 2014-3-5 16:52:45

如题，数据量稍微大点导出excel就用不了，后台也不报任何错误

znbyjn · 发表于 2014-3-5 17:00:29

有没有什么解决办法，着急着用

znbyjn · 发表于 2014-3-5 17:11:16

这是后来很长一段时间之后后台报出的信息：
[ERROR] 2014-03-05 17:01:29,751 com.justep.report.controller.OutputController - 报表输出失败
生成xls文件失败
com.justep.report.exception.ReportServerException: 报表输出失败
at com.justep.report.controller.OutputController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.CacheController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.ReportController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.DataController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.controller.InitController.execute(Unknown Source)
at com.justep.report.controller.GenericControllerChain.execute(Unknown Source)
at com.justep.report.Servlet.a(Unknown Source)
at com.justep.report.Servlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.RuntimeException: 生成xls文件失败
at com.justep.report.convertor.ExcelConvertor.generateByte(Unknown Source)
... 26 more
Caused by: java.lang.RuntimeException: Excel转换为二进制格式失败
at com.justep.report.convertor.ExcelConvertor.a(Unknown Source)
... 27 more
Caused by: java.lang.IllegalArgumentException: Invalid column index (256). Allowable column range for BIFF8 is (0..255) or ('A'..'IV')
at org.apache.poi.hssf.usermodel.HSSFCell.checkBounds(HSSFCell.java:943)
at org.apache.poi.hssf.usermodel.HSSFCell.<init>(HSSFCell.java:161)
at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:141)
at org.apache.poi.hssf.usermodel.HSSFRow.createCell(HSSFRow.java:119)
at com.justep.report.convertor.ExcelConvertor.a(Unknown Source)
at com.justep.report.convertor.ExcelConvertor.a(Unknown Source)
... 28 more

jishuang · 发表于 2014-3-5 17:41:32

报表的导出？里面是不是有特殊的字段类型？

wangliang · 发表于 2014-3-5 17:42:25

数据少正常？发一下 w文件

znbyjn · 发表于 2014-3-5 17:42:32

特殊类型指的是哪些？

znbyjn · 发表于 2014-3-5 17:55:20

检查了下，只有varchar2和decimal类型。这是相关.w文件和js文件

jishuang · 发表于 2014-3-6 09:10:49

参考http://blog.csdn.net/mynameiscloud/article/details/7405965
这个是office2003的限制

znbyjn · 发表于 2014-3-6 09:36:50

客户端office版本问题？我用装2007和2010的机器均试过，都不行

jishuang · 发表于 2014-3-6 09:55:24

reprot组件用的excel文件是o7的还是03的？

		自动登录	找回密码
密码			注册

[处理中5] x5.2.5报表导出excel会卡死