XlsName Methods |
The XlsName type exposes the following members.
| Name | Description | |
|---|---|---|
|
|
Activate |
Activates a single cell, which must be inside the current selection.
To select a range of cells, use the Select method.
|
|
|
Activate(Boolean) |
Activates a single cell, which must be inside the current selection.
To select a range of cells, use the Select method.
|
|
|
AddComment |
Adds comment to the range.
|
|
|
AddReference |
Increase the quantity of reference. User must use this method when
new wrapper on object is created or reference on object stored.
(Inherited from
XlsObject
.)
|
|
|
AutoFitColumns |
Autofits all columns in the range.
|
|
|
AutoFitRows |
Autofits all rows in the range.
|
|
|
BorderAround |
Sets around border for current range.
|
|
|
BorderAround(LineStyleType) |
Sets around border for current range.
|
|
|
BorderAround(LineStyleType, ExcelColors) |
Sets around border for current range.
|
|
|
BorderAround(LineStyleType, Color) |
Sets around border for current range.
|
|
|
BorderInside |
Sets inside border for current range.
|
|
|
BorderInside(LineStyleType) |
Sets inside border for current range.
|
|
|
BorderInside(LineStyleType, ExcelColors) |
Sets inside border for current range.
|
|
|
BorderInside(LineStyleType, Color) |
Sets inside border for current range.
|
|
|
BorderNone |
Sets none border for current range.
|
|
|
CheckDisposed |
Checks whether object was disposed and throws exception if it was.
(Inherited from
XlsObject
.)
|
|
|
Clear(Boolean) |
Clear the contents of the Range with formatting.
|
|
|
Clear(ExcelClearOptions) |
Clears the Content, formats, comments based on clear option.
|
|
|
ClearContents |
Clear the contents of the Range.
|
|
|
Clone(Object) |
Creates a new object that is a copy of the current instance.
|
|
|
Clone(Object, Dictionary String, String , XlsWorkbook) |
Obsolete.
Creates a clone of the current IXLSRange object.
|
|
|
CollapseGroup |
Collapses current group.
|
|
|
ConvertFullRowColumnName |
Obsolete.
Converts full row or column tokens between versions.
|
|
|
CopyTo |
Copies the range to the specified destination Range (without updating formulas).
|
|
|
Delete |
Removes this Name object from the workbook's Names collection.
|
|
|
Dispose |
Dispose object and free resources.
(Inherited from
XlsObject
.)
|
|
|
Equals |
Determines whether the specified object is equal to the current object.
(Inherited from
Object
.)
|
|
|
ExpandGroup(GroupByType) |
Expands current group.
|
|
|
ExpandGroup(GroupByType, ExpandCollapseFlags) |
Expands current group.
|
|
|
ExportDataTable |
Exports data from a specified range to a DataTable based on the provided export options.
|
|
|
Finalize |
Destructor. Call dispose method of current object.
(Inherited from
XlsObject
.)
|
|
|
FindAll(Boolean) |
This method seraches for the all cells with specified bool value.
|
|
|
FindAll(DateTime) |
This method seraches for the all cells with specified DateTime value.
|
|
|
FindAll(TimeSpan) |
This method seraches for the all cells with specified TimeSpan value.
|
|
|
FindAll(Double, FindType) |
This method seraches for the all cells with specified double value.
|
|
|
FindAll(String, FindType) |
This method seraches for the all cells with specified string value.
|
|
|
FindFirst(Boolean) |
This method seraches for the first cell with specified bool value.
|
|
|
FindFirst(DateTime) |
This method seraches for the first cell with specified DateTime value.
|
|
|
FindFirst(TimeSpan) |
This method seraches for the first cell with specified TimeSpan value.
|
|
|
FindFirst(Double, FindType) |
This method seraches for the first cell with specified double value.
|
|
|
FindFirst(String, FindType) |
This method seraches for the first cell with specified string value.
|
|
|
FindParent(Type) |
This method is used to find parent with specific type.
(Inherited from
XlsObject
.)
|
|
|
FindParent( Type ) |
Find parent of object.
(Inherited from
XlsObject
.)
|
|
|
FindParent(Type, Boolean) |
This method is used to find parent with specific type.
(Inherited from
XlsObject
.)
|
|
|
FindParents |
Finds parent objects.
(Inherited from
XlsObject
.)
|
|
|
FreezePanes |
Freezes pane at the current range.
|
|
|
GetEnumerator |
Returns an enumerator that iterates through the RefersToRange collection.
|
|
|
GetHashCode |
Serves as the default hash function.
(Inherited from
Object
.)
|
|
|
GetType |
Gets the
Type
of the current instance.
(Inherited from
Object
.)
|
|
|
Intersect |
Returns intersection of this range with the specified one.
|
|
|
MemberwiseClone |
Creates a shallow copy of the current
Object
.
(Inherited from
Object
.)
|
|
|
Merge |
Creates a merged cell from the specified Range object.
|
|
|
Merge(Boolean) |
Creates a merged cell from the specified Range object.
|
|
|
Merge(IXLSRange) |
Returns merge of this range with the specified one.
|
|
|
OnDispose |
Method which can be overriden by users to take any specific actions when
object is disposed.
(Inherited from
XlsObject
.)
|
|
|
ReleaseReference |
Decrease quantity of Reference. User must call this method
when freeing resources.
(Inherited from
XlsObject
.)
|
|
|
SetIndex(Int32) |
Obsolete.
Sets index of the named range and raise event.
|
|
|
SetIndex(Int32, Boolean) |
Obsolete.
Sets index of the named range.
|
|
|
SetParent |
Sets parent of the object.
(Inherited from
XlsObject
.)
|
|
|
ToString |
Returns a string that represents the current object.
(Inherited from
Object
.)
|
|
|
UnMerge |
Separates a merged area into individual cells.
|