交叉报表生成EXCEL失败

chean

做了个交叉报表，分组下需要有三个分类，但现在只能添加 2 个，再添加一个的话就报错。。

wangliang

在excel 顶部插入几行空行试试，不行的话发下W文件

jishuang

把详细的错误信息发一下

chean

jishuang 发表于 2014-2-17 17:30
把详细的错误信息发一下

2014-02-17 17:44:34 开始-WINDOW生成中间文件: /UI/JGPS/report/process/jgpsreport/xsqktj.w
2014-02-17 17:44:38 Excel生成报表定义失败，文件名：E:\X5.2.6_dev_201401\X5.2.6\model\UI\JGPS\report\process\jgpsreport\reports\xsqktj_crossReport.xls
javax.servlet.ServletException: java.lang.RuntimeException: Excel生成报表定义失败，文件名：E:\X5.2.6_dev_201401\X5.2.6\model\UI\JGPS\report\process\jgpsreport\reports\xsqktj_crossReport.xls
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        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: Excel生成报表定义失败，文件名：E:\X5.2.6_dev_201401\X5.2.6\model\UI\JGPS\report\process\jgpsreport\reports\xsqktj_crossReport.xls
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at com.justep.xbl.report.Report.generateReportDoc(Report.java:352)
        at com.justep.xbl.report.Report.generateReportDefine(Report.java:321)
        at com.justep.xbl.report.Report.execute(Report.java:71)
        at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
        at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
        at com.justep.ui.util.UIUtils.xbl(Unknown Source)
        at com.justep.ui.WindowCompiler.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler.compile(Unknown Source)
        at com.justep.ui.WindowServer.getWindow(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        ... 14 more
Caused by: java.lang.RuntimeException: Excel生成报表定义失败
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        ... 31 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 5
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        ... 32 more
2014-2-17 17:44:38 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet main-servlet threw exception
java.lang.ArrayIndexOutOfBoundsException: 5
        at com.justep.xls.Worksheet.getCell(Unknown Source)
        at com.justep.report.xls.XLSTransUtils.getSpan(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.a(Unknown Source)
        at com.justep.report.xls.XLSTransContent.scanCols(Unknown Source)
        at com.justep.report.xls.XLSTransContent.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at com.justep.report.xls.XLSTransformer.transform(Unknown Source)
        at com.justep.xbl.report.Report.generateReportDoc(Report.java:352)
        at com.justep.xbl.report.Report.generateReportDefine(Report.java:321)
        at com.justep.xbl.report.Report.execute(Report.java:71)
        at com.justep.xbl.runtime.TemplateEngine.computeJavaTemplate(Unknown Source)
        at com.justep.xbl.runtime.TemplateEngine.exeucte(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parserBinding(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.parser(Unknown Source)
        at com.justep.xbl.runtime.XBLEngine.excute(Unknown Source)
        at com.justep.ui.util.UIUtils.xbl(Unknown Source)
        at com.justep.ui.WindowCompiler.w2Middle(Unknown Source)
        at com.justep.ui.WindowCompiler.compile(Unknown Source)
        at com.justep.ui.WindowServer.getWindow(Unknown Source)
        at com.justep.ui.WindowServer.service(Unknown Source)
        at com.justep.ui.servlet.MainServlet.service(Unknown Source)
        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)

chean

wangliang 发表于 2014-2-17 17:30
在excel 顶部插入几行空行试试，不行的话发下W文件

我去，，添加空行，，可以了，这是为什么 呢。？？？
有人能给出原因吗？？
结贴吧！