org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:191) at org.apache.poi.hssf.record.RecordFactory.createRecords (RecordFactory.java:115) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:205) at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init> (HSSFWorkbook.java:153) at com.mdcl.fmcc.cron.ReadExcel.getSheetList(ReadExcel.java:67) at com.mdcl.fmcc.cron.ReadExcel.main(ReadExcel.java:53) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at org.apache.poi.hssf.record.RecordFactory.createRecord (RecordFactory.java:179) ... 5 more Caused by: java.lang.UnsupportedOperationException: Unknown Ptg in Formula: 0x0 (0) at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:357) at org.apache.poi.hssf.record.formula.Ptg.createParsedExpressionTokens (Ptg.java:98) at org.apache.poi.hssf.record.NameRecord.fillFields(NameRecord.java:740) at org.apache.poi.hssf.record.Record.<init>(Record.java:56) at org.apache.poi.hssf.record.NameRecord.<init>(NameRecord.java:143) ... 10 more
Is this problem still occuring with a svn checkout of poi? If so, please attach the problem excel file
There has been quite a bit of work with the latest POI-3.5beta5. You should try it to see if it solves this formula ptg problem. Please let us know. Without useful information for over a year, I am resolving this as "INVALID" - admittedly arbitrary as it may more properly be "FIXED"