Hello,
Shoukd this line;
AreaReference ar = new AreaReference(range.getReference());
not read this;
AreaReference ar = new AreaReference(range.getNameName());
The getNameName() method returns a String that identifies the named range,
getReference() returns a forumla.
Yingxue Feng wrote:
>
> Hi
>
> /*
> * Get column of a name range
> */
> private static short getNamedRangeColumn (HSSFWorkbook wb, String name)
> {
> int namedCellIdx = wb.getNameIndex(name);
> HSSFName range = wb.getNameAt(namedCellIdx);
>
> AreaReference ar = new AreaReference(range.getReference());
> CellReference[] cells = ar.getAllReferencedCells();
>
> // Store the column of the named range;
> short rShort = cells[0].getCol();
>
> // memory cleanup
> range = null;
> ar = null;
> cells = null;
>
> return rShort;
>
> }
>
> I upload template xls, and I got the following error:
>
> java.lang.IllegalArgumentException: Invalid Formula cell reference:
> 'Tasks!D'
> at
> org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:61)
> at
> org.apache.poi.hssf.util.AreaReference.<init>(AreaReference.java:63)
> at
> com.cypress.cyplm.servlet.AdminTaskSetEditAction.getNamedRangeColumn(AdminTaskSetEditAction.java:145)
> at
> com.cypress.cyplm.servlet.AdminTaskSetEditAction.processWorkbook(AdminTaskSetEditAction.java:171)
> at
> com.cypress.cyplm.servlet.AdminTaskSetEditAction.save(AdminTaskSetEditAction.java:593)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>
> the poi version we use is 3.1-FINAL, we just changed it back from 3.2. we
> do
> not want to update poi to 3.2 cos it may bring other issues with our
> codes.
>
> so the questions is, how to fix the issue? thanks
>
>
--
View this message in context:
http://www.nabble.com/get-a-column-of-a-name-range-issue-tp22315130p22336096.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
