inamedrange-ag凯发旗舰厅



com.spire.xls.core
interface inamedrange

all known implementing classes:
xlsname

public interface inamedrange

represents a defined name for a range of cells. names can be either built-in names such as database, print_area, and auto_open or custom names.


method summary
 void delete()
          deletes the object.
 int getindex()
          returns the index number of the object within the collection of similar objects.
 java.lang.string getname()
          returns or sets the name of the object.
 java.lang.string getnamelocal()
          returns or sets the name of the object, in the language of the user.
 ixlsrange getreferstorange()
          returns the range object referred to by a name object.
 java.lang.string getscope()
          returns string representation of the name's scope.
 java.lang.string getvalue()
          for the name object, a string containing the formula that the name is defined to refer to.
 java.lang.string getvaluer1c1()
          gets named range formula in r1c1 style.
 boolean getvisible()
          determines whether the object is visible.
 iworksheet getworksheet()
          returns parent worksheet.
 boolean islocal()
          indicates whether name is local.
 void setname(java.lang.string value)
          returns or sets the name of the object.
 void setnamelocal(java.lang.string value)
          returns or sets the name of the object, in the language of the user.
 void setreferstorange(ixlsrange referstorange)
          sets the range object referred to a name object.
 void setvalue(java.lang.string value)
          for the name object, a string containing the formula that the name is defined to refer to.
 void setvisible(boolean value)
          determines whether the object is visible.
 
method detail

getindex

int getindex()
returns the index number of the object within the collection of similar objects. read-only long.

getname

java.lang.string getname()
returns or sets the name of the object. read / write string.

setname

void setname(java.lang.string value)
returns or sets the name of the object. read / write string.

getnamelocal

java.lang.string getnamelocal()
returns or sets the name of the object, in the language of the user. read / write string for name.

setnamelocal

void setnamelocal(java.lang.string value)
returns or sets the name of the object, in the language of the user. read / write string for name.

getreferstorange

ixlsrange getreferstorange()
returns the range object referred to by a name object. read-only.

setreferstorange

void setreferstorange(ixlsrange referstorange)
sets the range object referred to a name object. read-only.

getvalue

java.lang.string getvalue()
for the name object, a string containing the formula that the name is defined to refer to. the string is in a1-style notation in the language of the macro, and it begins with an equal sign.

setvalue

void setvalue(java.lang.string value)
for the name object, a string containing the formula that the name is defined to refer to. the string is in a1-style notation in the language of the macro, and it begins with an equal sign.

getvisible

boolean getvisible()
determines whether the object is visible. read / write boolean.

setvisible

void setvisible(boolean value)
determines whether the object is visible. read / write boolean.

islocal

boolean islocal()
indicates whether name is local.

getvaluer1c1

java.lang.string getvaluer1c1()
gets named range formula in r1c1 style. read only.

getworksheet

iworksheet getworksheet()
returns parent worksheet. read-only.

getscope

java.lang.string getscope()
returns string representation of the name's scope. read-only.

delete

void delete()
deletes the object.


网站地图