I am trying to read a formula as is from the excel file.
The formula is =CHOOSE(2,A2,A3,A4)
But I am getting the following error.
Exception in thread "main" 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:257)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:238)
at excelFileReader.ParseExcel.main(ParseExcel.java:14)
Caused by: 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:179)
... 5 more
Caused by: org.apache.poi.hssf.record.RecordFormatException:
java.lang.UnsupportedOperationException: Unknown Ptg in Formula: 0x0 (0)
at
org.apache.poi.hssf.record.FormulaRecord.fillFields(FormulaRecord.java:109)
at org.apache.poi.hssf.record.Record.<init>(Record.java:56)
at
org.apache.poi.hssf.record.FormulaRecord.<init>(FormulaRecord.java:89)
... 10 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.FormulaRecord.fillFields(FormulaRecord.java:107)
... 12 more
Can somebody pls help me.
--
View this message in context:
http://www.nabble.com/Problem-reading-excel-formula-tf3890132.html#a11027555
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
