Excel导出问题

qizi

按照向导做的网格报表，昨天下午还能正常导出excel格式文件，今天早晨导出pdf，word都可以，但是无法导出excel，请见附件excel。

jishuang

tomcat控制台不报错？
把报表的excel文件发一下看看

qizi

jishuang 发表于 2017-6-9 10:37
tomcat控制台不报错？
把报表的excel文件发一下看看

报表excel文件见附件。

qizi

请看以下报错信息

qizi

这是刚才导出excel时报的错误。

[ERROR] 2017-06-09 10:50:45,596 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:643)
        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)
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

excel文件发的有问题重新发一下

qizi

mainActivityReport.xml这个文件我保存了一下，突然就好了，这也太奇怪了吧！不过还是感谢您！