(本文档仅供参考)

问题说明:

电子表格打开报错如下:

ERROR a(smartbi.dm:688) - Invalid column index.
java.lang.IllegalArgumentException: Invalid column index.
at com.aspose.cells.zaqm.b(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.ColumnCollection.get(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.zaiw.<init>(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.zaiy.b(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.zaiu.a(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.zaiz.b(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.zaiz.a(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.Workbook.a(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at com.aspose.cells.Workbook.save(Unknown Source) ~[cells-cells-20.1.jar:20.1.0]
at smartbi.do.a(Smartbi:442) ~[smartbi-SpreadsheetReport.jar:?]
at smartbi.do.d(Smartbi:262) ~[smartbi-SpreadsheetReport.jar:?]
at smartbi.dm.a(Smartbi:677) [smartbi-SpreadsheetReport.jar:?]
at smartbi.dm.a(Smartbi:111) [smartbi-SpreadsheetReport.jar:?]
at smartbi.dm$1.a(Smartbi:597) [smartbi-SpreadsheetReport.jar:?]
at smartbi.dm$1.call(Smartbi:595) [smartbi-SpreadsheetReport.jar:?]
at smartbi.freequery.client.simplereport.JobService$3.call(JobService.java:145) [smartbi-FreeQuery.jar:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_281]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_281]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_281]


原因分析:

此报错通常是超出了Excel的最大列号:XFD(16384列),若横向扩展字段的数据量没这么大,则需要排查一下电子表格中是否由于误操作导致大量的空白列生效了。