Warning: Cannot merge cells – top left and bottom right incorrectly specified
报上面这个错误
Warning: Cannot merge cells – top left and bottom right incorrectly specified
20161021:11:26:45.969 INFO Excel文件头写入开始…
20161021:11:26:45.973 INFO 表头信息解析:{field={}, dict={}, split={}}
20161021:11:26:45.973 INFO Excel文件头写入完成.
20161021:11:26:45.973 INFO Excel文件标题写入开始…
20161021:11:26:45.977 ERROR Excel文件写入出错了,-1
java.lang.ArrayIndexOutOfBoundsException: -1
at jxl.write.biff.RowRecord.addCell(RowRecord.java:247) ~[jxl-2.6.12.jar:na]
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1191) ~[jxl-2.6.12.jar:na]
at jxl.write.biff.WritableSheetImpl.mergeCells(WritableSheetImpl.java:1855) ~[jxl-2.6.12.jar:na]
at com.daohe.production.base.report.ReportExportExt.createEXCLFile(ReportExportExt.java:515) [DH.BASE-2.0.1-RELEASE.jar:na]
at com.daohe.production.base.report.ReportExportExt.createEXCLFile(ReportExportExt.java:149) [DH.BASE-2.0.1-RELEASE.jar:na]
at com.daohe.production.hbase.lib.ReportExportLibExt.createFileToExcl(ReportExportLibExt.java:51) [dh.mbpay.base-1.0-release.jar:na]
at com.daohe.production.hbase.service.impl.ReportServiceImpl.reportExcel(ReportServiceImpl.java:339) [dh.mbpay.base-1.0-release.jar:na]
at com.daohe.production.hbase.service.impl.ReportServiceImpl.report(ReportServiceImpl.java:57) [dh.mbpay.base-1.0-release.jar:na]
at com.daohe.production.mng.service.impl.MobileMerServiceImpl.report(MobileMerServiceImpl.java:95) [dh.mbpay.mng-1.0-release.jar:na]
at com.daohe.production.mng.service.impl.MobileMerServiceImpl$$FastClassBySpringCGLIB$$9da4ef41.invoke(<generated>) [spring-core-4.0.3.RELEASE.jar:na]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.0.3.RELEASE.jar:4.0.3.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:640) [spring-aop-4.0.3.RELEASE.jar:4.0.3.RELEASE]
at com.daohe.production.mng.service.impl.MobileMerServiceImpl$$EnhancerBySpringCGLIB$$c5985c44.report(<generated>) [spring-core-4.0.3.RELEASE.jar:na]
at com.daohe.production.hbase.trans.ReportTran.trans_800001(ReportTran.java:43) [dh.mbpay.base-1.0-release.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_80]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_80]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_80]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_80]
at com.daohe.production.comm.engine.CodeService.processDoWithNotimeOut(CodeService.java:278) [DH.COMM-2.0.1-release.jar:na]
at com.daohe.production.comm.rpc.AsyService.AsynService$1.run(AsynService.java:101) [DH.COMM-2.0.1-release.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_80]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
20161021:11:26:46.525 INFO Excel文件关闭
报上面这个错误
Warning: Cannot merge cells – top left and bottom right incorrectly specified
20161021:11:26:45.969 INFO Excel文件头写入开始…
20161021:11:26:45.973 INFO 表头信息解析:{field={}, dict={}, split={}}
20161021:11:26:45.973 INFO Excel文件头写入完成.
20161021:11:26:45.973 INFO Excel文件标题写入开始…
20161021:11:26:45.977 ERROR Excel文件写入出错了,-1
java.lang.ArrayIndexOutOfBoundsException: -1
at jxl.write.biff.RowRecord.addCell(RowRecord.java:247) ~[jxl-2.6.12.jar:na]
at jxl.write.biff.WritableSheetImpl.addCell(WritableSheetImpl.java:1191) ~[jxl-2.6.12.jar:na]
at jxl.write.biff.WritableSheetImpl.mergeCells(WritableSheetImpl.java:1855) ~[jxl-2.6.12.jar:na]
at com.daohe.production.base.report.ReportExportExt.createEXCLFile(ReportExportExt.java:515) [DH.BASE-2.0.1-RELEASE.jar:na]
at com.daohe.production.base.report.ReportExportExt.createEXCLFile(ReportExportExt.java:149) [DH.BASE-2.0.1-RELEASE.jar:na]
at com.daohe.production.hbase.lib.ReportExportLibExt.createFileToExcl(ReportExportLibExt.java:51) [dh.mbpay.base-1.0-release.jar:na]
at com.daohe.production.hbase.service.impl.ReportServiceImpl.reportExcel(ReportServiceImpl.java:339) [dh.mbpay.base-1.0-release.jar:na]
at com.daohe.production.hbase.service.impl.ReportServiceImpl.report(ReportServiceImpl.java:57) [dh.mbpay.base-1.0-release.jar:na]
at com.daohe.production.mng.service.impl.MobileMerServiceImpl.report(MobileMerServiceImpl.java:95) [dh.mbpay.mng-1.0-release.jar:na]
at com.daohe.production.mng.service.impl.MobileMerServiceImpl$$FastClassBySpringCGLIB$$9da4ef41.invoke(<generated>) [spring-core-4.0.3.RELEASE.jar:na]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) [spring-core-4.0.3.RELEASE.jar:4.0.3.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:640) [spring-aop-4.0.3.RELEASE.jar:4.0.3.RELEASE]
at com.daohe.production.mng.service.impl.MobileMerServiceImpl$$EnhancerBySpringCGLIB$$c5985c44.report(<generated>) [spring-core-4.0.3.RELEASE.jar:na]
at com.daohe.production.hbase.trans.ReportTran.trans_800001(ReportTran.java:43) [dh.mbpay.base-1.0-release.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_80]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_80]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_80]
at java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_80]
at com.daohe.production.comm.engine.CodeService.processDoWithNotimeOut(CodeService.java:278) [DH.COMM-2.0.1-release.jar:na]
at com.daohe.production.comm.rpc.AsyService.AsynService$1.run(AsynService.java:101) [DH.COMM-2.0.1-release.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_80]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_80]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]
20161021:11:26:46.525 INFO Excel文件关闭
解决方案
10
数组越界 debug看哪行报错,贴相关代码
10
Cannot merge cells – top left and bottom right incorrectly specified
你合并单元格了吗? ArrayIndexOutOfBoundsException 下标问题找找代码
at com.daohe.production.base.report.ReportExportExt.createEXCLFile(ReportExportExt.java:515)
你合并单元格了吗? ArrayIndexOutOfBoundsException 下标问题找找代码
at com.daohe.production.base.report.ReportExportExt.createEXCLFile(ReportExportExt.java:515)
10
java.lang.ArrayIndexOutOfBoundsException: -1
at jxl.write.biff.RowRecord.addCell(RowRecord.java:247) ~[jxl-2.6.12.jar:na]
at jxl.write.biff.RowRecord.addCell(RowRecord.java:247) ~[jxl-2.6.12.jar:na]
10
java.lang.ArrayIndexOutOfBoundsException: -1 下标越界了