页面树结构
转至元数据结尾
转至元数据起始

(本文档仅供参考)

问题说明

仪表盘报错如下:

导出出错
at smartbi.module.export.service.AbstractResourceExportService.export(AbstractResourceExportService.java:220)
at smartbix.smartbi.export.page.ExcelExporter.fillData(ExcelExporter.java:277)
Caused by:java.lang.llegalArgumentException:Invalid rowindex.
at com.aspose.cells.zark.a(Unknown Source)
at com.aspose.cells.Cells.get(Unknown Source)
at smartbix.smartbi.export.page.ExcelExporter.fillData(ExcelExporter.java:277)
at smartbix.smartbi.export.page.ExcelExporter.export(ExcelExporter.java:195)
at smartbi.module.export.service.AbstractResourceExportService.export(AbstractResourceExportServicejava:150)
at smartbi.module.export.actions.AbstractExportAction.doExport(AbstractExportActionjava:54)
at smartbi.module.export.actions.AbstractExportAction.process(AbstractExportActionjava:41)
at smartbimodule.export.ExportHttpServlet.processRequest(ExportHttpServlet.java:127)
at smartbi.module.export.ExportHttpServlet.service(ExportHttpServlet.java:80)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDofilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChainjava:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilterjava:51)
at org.apache.catalinacore.ApplicationFilterChain.internalDoFilter(ApplicationFilterChainjava:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChainjava:153)
at smartbiextension.ExtensionFilterS1.doFilter(ExtensionFilterjava:249)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilterjava:273)
at smartbi.aichat.AIChatFilter.doFilter(AIChatFilter.java:56)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilterjava:273)
at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilterjava:273)
at smartbi.weixin.filter.WxLoginFilter.doFilter(WxLoginFilterjava:212)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
at smartbi.extension.ExtensionFilter.doFilterlnternal(ExtensionFilter.java:276)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilterjava:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChainjava:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at smartbi.framework.rmi.TransactionFilter.doFilter(TransactionFilterjava:87)
at org.apache.catalinacore.ApplicationFilterChain.internalDoFilter(ApplicationFilterChainjava:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChainjava:153)
at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilterjava:96)
at org.apache.catalinacore.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChainjava:153)
at smartbi.freequery.filter.ChecklsLoggedFilter.doFilter(CheckisLoggedFilterjava:189)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)


解决方案

Invalid rowindex:这个异常通常意味着试图访问的行号,超出了Excel工作表的有效范围。在 Excel 2007 及以后版本中,最大行数是 1048576。

如下设置项的最大值,应是1048576-1=1048575,若是设置1048576,当数据量本身超出或等于1048576行数据(超出配置项的数据量,按照配置项导出),导出时加上表头,那么就超出了Excel工作表的有效范围,就会出现Invalid rowindex异常。


  • 无标签