-
-
lium 小试身手Lv3
发表于2018-10-24 17:40
悬赏1
已解决
楼主
分析表导出的时候,提示

最佳答案
lium 发表于 2018-10-24 17:46
BI46,导出Excel。
2018-10-24 17:46:19.297 构造导出用的报表...
2018-10-24 17:46:19.297 构造报表完毕 ...
按照报错的提示,是列超过1024列。您的报表超过1024列吗?再者导出的excel的版本是03还是07呢
4个回答
wut 发表于 2018-10-24 17:44
导出excel报错?什么版本的BI,可以把报错详情复制给我吗?
BI46,导出Excel。
2018-10-24 17:46:19.297 构造导出用的报表...
2018-10-24 17:46:19.297 构造报表完毕,正在导出报表:B05明细表(渔产品)...
java.lang.IllegalArgumentException: dx1 must be between 0 and 1023
at org.apache.poi.hssf.usermodel.HSSFClientAnchor.checkRange(HSSFClientAnchor.java:261)
at org.apache.poi.hssf.usermodel.HSSFClientAnchor.(HSSFClientAnchor.java:60)
at com.esen.bi.export.impl.excel.Sheet4ReportPage.relativeText(ReportPage2Excel.java:2939)
at com.esen.bi.export.impl.excel.Sheet4ReportPage.createAnchor(ReportPage2Excel.java:2771)
at com.esen.bi.export.impl.excel.Sheet4ReportPage.addWidgetText(ReportPage2Excel.java:753)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.esen.bi.export.impl.excel.BaseSheet.addOneWidgetObject(BaseSheet.java:405)
at com.esen.bi.export.impl.excel.BaseSheet.addWaitList(BaseSheet.java:362)
at com.esen.bi.export.impl.excel.BaseSheet.draw(BaseSheet.java:353)
at com.esen.bi.export.impl.excel.ReportPageExport2Excel.createSheet(ReportPageExport2Excel.java:75)
at com.esen.bi.export.impl.excel.ReportPageExport2Excel.addReportInOneSheet(ReportPageExport2Excel.java:61)
at com.esen.bi.export.impl.excel.ReportPageExportExcelImpl.exportOnePage(ReportPageExportExcelImpl.java:158)
at com.esen.bi.export.AbstractReportPageExport.addReport(AbstractReportPageExport.java:249)
at com.esen.bi.export.AbstractReportPageExport.add(AbstractReportPageExport.java:144)
at com.esen.irpt.req.RequestTask_exportReportPage.doRun(RequestTask_exportReportPage.java:128)
at com.esen.irpt.req.AbstractRequestTask.call(AbstractRequestTask.java:85)
at com.esen.platform.common.req.RequestTaskRunner.call(RequestTaskRunner.java:74)
at com.esen.thread.LocaleTask.call(LocaleTask.java:60)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
页面地址为:【/bi45/exportreportpage.do?action=query;last_getlogs_count=0;id=742】
JavaScript StackTrace:
Error: dx1 must be between 0 and 1023
--detailmessage--
2018-10-24 17:46:19.297 构造导出用的报表...
2018-10-24 17:46:19.297 构造报表完毕,正在导出报表:B05明细表(渔产品)...
java.lang.IllegalArgumentException: dx1 must be between 0 and 1023
at org.apache.poi.hssf.usermodel.HSSFClientAnchor.checkRange(HSSFClientAnchor.java:261)
at org.apache.poi.hssf.usermodel.HSSFClientAnchor.(HSSFClientAnchor.java:60)
at com.esen.bi.export.impl.excel.Sheet4ReportPage.relativeText(ReportPage2Excel.java:2939)
at com.esen.bi.export.impl.excel.Sheet4ReportPage.createAnchor(ReportPage2Excel.java:2771)
at com.esen.bi.export.impl.excel.Sheet4ReportPage.addWidgetText(ReportPage2Excel.java:753)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.esen.bi.export.impl.excel.BaseSheet.addOneWidgetObject(BaseSheet.java:405)
at com.esen.bi.export.impl.excel.BaseSheet.addWaitList(BaseSheet.java:362)
at com.esen.bi.export.impl.excel.BaseSheet.draw(BaseSheet.java:353)
at com.esen.bi.export.impl.excel.ReportPageExport2Excel.createSheet(ReportPageExport2Excel.java:75)
at com.esen.bi.export.impl.excel.ReportPageExport2Excel.addReportInOneSheet(ReportPageExport2Excel.java:61)
at com.esen.bi.export.impl.excel.ReportPageExportExcelImpl.exportOnePage(ReportPageExportExcelImpl.java:158)
at com.esen.bi.export.AbstractReportPageExport.addReport(AbstractReportPageExport.java:249)
at com.esen.bi.export.AbstractReportPageExport.add(AbstractReportPageExport.java:144)
at com.esen.irpt.req.RequestTask_exportReportPage.doRun(RequestTask_exportReportPage.java:128)
at com.esen.irpt.req.AbstractRequestTask.call(AbstractRequestTask.java:85)
at com.esen.platform.common.req.RequestTaskRunner.call(RequestTaskRunner.java:74)
at com.esen.thread.LocaleTask.call(LocaleTask.java:60)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
lium 发表于 2018-10-24 17:46
BI46,导出Excel。
2018-10-24 17:46:19.297 构造导出用的报表...
2018-10-24 17:46:19.297 构造报表完毕 ...
按照报错的提示,是列超过1024列。您的报表超过1024列吗?再者导出的excel的版本是03还是07呢
lium 发表于 2018-10-24 17:46
BI46,导出Excel。
2018-10-24 17:46:19.297 构造导出用的报表...
2018-10-24 17:46:19.297 构造报表完毕 ...
请问下您的问题解决了?