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