poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Mui <da...@muibros.com>
Subject Re: How to modify cells using the named range
Date Tue, 25 Mar 2003 18:04:09 GMT
That method simply gives you a HSSFName object that gives you the 
formula-based reference (i.e Sheet1!A2:A5).

You can use:

http://jakarta.apache.org/poi/javadocs/org/apache/poi/hssf/util/AreaReference.html

|AreaReference ref = new AreaReference (name.getReference());

That will get you your cell indices, albeit the long way.  Maybe this 
should be easier?

danny
|

Clauss, Arne wrote:

>Hello!
>
>I would like to modify an excel-file in an web-application. Because the
>design of the excel-file could be changed I would like to use the named
>ranges for putting the information into the excel-file. I think, that this
>make me independent of design changes (adding new rows an columns).
>
>I just want to get a cell for modifying it by the using the named range of
>the cell to find it.
>
>I have found in the class "HSSFWorkbook" the method "getNameIndex". What
>should I do with the returned index. I haven't found a method for getting a
>HSSFCell with the returned index. 
>
>Any help is appreciated.
>
>Kind regards,
>
>Arne
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>  
>



Mime
View raw message