Apache POI InvocationTargetException
Just disable Auto-filter or Advanced filters in your Excel Sheet. You can find filters in the Data Menu –> Filter.
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:224)
at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:160)at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(
HSSFWorkbook.java:163)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130)at com.ml.cortex.utils.excel.ExcelUtils.<init>(
ExcelUtils.java:30)
at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.getRequestObject(MIF2DataSOAExecutor.java:185)at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.process(
MIF2DataSOAExecutor.java:323)
at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.main(MIF2DataSOAExecutor.java:574)
Caused by: java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at org.apache.poi.hssf.record.UnknownRecord.<init>(UnknownRecord.java:62)at org.apache.poi.hssf.record.SubRecord.createSubRecord(
SubRecord.java:57)
at org.apache.poi.hssf.record.ObjRecord.fillFields(ObjRecord.java:99)at org.apache.poi.hssf.record.Record.fillFields(
Record.java:90)
at org.apache.poi.hssf.record.Record.<init>(Record.java:55)at org.apache.poi.hssf.record.ObjRecord.<init>(
ObjRecord.java:61)
… 12 more
org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance, the following exception occured: null
at org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:237)at org.apache.poi.hssf.record.RecordFactory.createRecords(
RecordFactory.java:160)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(
HSSFWorkbook.java:130)
at com.ml.cortex.utils.excel.ExcelUtils.<init>(ExcelUtils.java:30)at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.getRequestObject(
MIF2DataSOAExecutor.java:185)
at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.process(MIF2DataSOAExecutor.java:323)
at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.main(MIF2DataSOAExecutor.java:574)
java.lang.RuntimeException
at com.ml.cortex.utils.file.FileUtil.getFileNames(FileUtil.java:659)
at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.doTheDiff(MIF2DataSOAExecutor.java:755)at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.process(
MIF2DataSOAExecutor.java:348)
at com.ml.cortex.apps.eds.mif2datasoa.MIF2DataSOAExecutor.main(MIF2DataSOAExecutor.java:574)
