You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Michael Gray <mg...@phoenix-int.com> on 2009/07/06 18:47:27 UTC
IndexOutOfBoundsException in XLS2CSVmra
I'm using POI 3.2 FINAL and I'm trying to run xsl2csvmra but I am getting an IndexOutOfBoundsException for the HSSFFormulaParser.toFormulaString. I cannot figure out what is wrong.
The file is simple, nothing more than a few numbers, named ranges, and formulas.
It works if I don't try and get the formulas, but I need the formulas for what I am doing.
The formula it crashes at is: =(2*N*(d_1*d_1+d_2*d_2)*(d_1+d_2))
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 6, Size: 0
at java.util.ArrayList.RangeCheck(ArrayList.java:547)
at java.util.ArrayList.get(ArrayList.java:322)
at org.apache.poi.hssf.model.LinkTable.getNameRecord(LinkTable.java:264)
at org.apache.poi.hssf.model.Workbook.getNameRecord(Workbook.java:1994)
at org.apache.poi.hssf.usermodel.HSSFEvaluationWorkbook.getNameText(HSSFEvaluationWorkbook.java:110)
at org.apache.poi.hssf.record.formula.NamePtg.toFormulaString(NamePtg.java:70)
at org.apache.poi.ss.formula.FormulaRenderer.toFormulaString(FormulaRenderer.java:92)
at org.apache.poi.hssf.model.HSSFFormulaParser.toFormulaString(HSSFFormulaParser.java:66)
at XLS2CSV.processRecord(XLS2CSV.java:203)
at org.apache.poi.hssf.eventusermodel.MissingRecordAwareHSSFListener.processRecord(MissingRecordAwareHSSFListener.java:157)
at org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener.processRecord(FormatTrackingHSSFListener.java:64)
at org.apache.poi.hssf.eventusermodel.EventWorkbookBuilder$SheetRecordCollectingListener.processRecord(EventWorkbookBuilder.java:170)
at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord(HSSFRequest.java:137)
at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents(HSSFEventFactory.java:143)
,
at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents(HSSFEventFactory.java:98)
at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processWorkbookEvents(HSSFEventFactory.java:63)
at XLS2CSV.process(XLS2CSV.java:126)
at XLS2CSV.main(XLS2CSV.java:323)
--
Michael Gray
Phoenix Integration