You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by javaexcel <ic...@yahoo.com> on 2007/06/08 16:27:39 UTC

Problem reading excel formula

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org