Re: How to modify cells using the named range

[Danny Mui]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]