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:


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

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


Clauss, Arne wrote:

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

View raw message