Click or drag to resize

XlsRangesCollection Methods

The XlsRangesCollection type exposes the following members.

Methods
Name Description
Public method Activate
Activages a single cell, scroll to it and activates the respective sheet To select a range of cells, use the Select method.
Protected method Add
Adds new range to the collection.
Public method AddComment
Adds comment to the range.
Protected method AddRange
Adds range to the collection.
Public method AutoFitColumns
Autofits all columns.
Public method AutoFitRows
Autofits all rows.
Public method BorderAround
Sets around border for current range.
Public method BorderAround(LineStyleType)
Sets around border for current range.
Public method BorderAround(LineStyleType, ExcelColors)
Sets around border for current range.
Public method BorderAround(LineStyleType, Color)
Sets around border for current range.
Public method BorderInside
Sets inside border for current range.
Public method BorderInside(LineStyleType)
Sets inside border for current range.
Public method BorderInside(LineStyleType, ExcelColors)
Sets inside border for current range.
Public method BorderInside(LineStyleType, Color)
Sets inside border for current range.
Public method BorderNone
Sets none border for current range.
Public method Clear
Removes all objects from the System.Collections.CollectionBase instance.
(Inherited from CollectionBase T .)
Public method ClearConditionalFormats
Clears conditional formats.
Public method Clone(Object)
Creates copy of the collection.
(Inherited from CollectionExtended T .)
Public method Clone(Object, Dictionary String, String , XlsWorkbook)
Clones current IXLSRange.
Public method CollapseGroup
Collapses current group.
Public method Contains
Determines whether the collection contains a specific item.
(Inherited from CollectionBase T .)
Public method CopyTo
Copies the elements of the collection to an array, starting at a particular array index.
(Inherited from CollectionBase T .)
Public method EnsureCapacity
Enlarges internal storage if necessary.
(Inherited from CollectionExtended T .)
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Public method ExpandGroup(GroupByType)
Expands current group.
Public method ExpandGroup(GroupByType, ExpandCollapseFlags)
Expands current group.
Public method ExportDataTable Obsolete.
Exports data to a DataTable based on the provided ExportTableOptions.
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Protected method FindAll(Boolean)
This method seraches for the all cells with specified bool value.
Protected method FindAll(DateTime)
This method seraches for the all cells with specified DateTime value.
Protected method FindAll(TimeSpan)
This method seraches for the all cells with specified TimeSpan value.
Protected method FindAll(Double, FindType)
This method seraches for the all cells with specified double value.
Protected method FindAll(String, FindType)
This method seraches for the all cells with specified string value.
Protected method FindFirst(Boolean)
This method seraches for the first cell with specified bool value.
Protected method FindFirst(DateTime)
This method seraches for the first cell with specified DateTime value.
Protected method FindFirst(TimeSpan)
This method seraches for the first cell with specified TimeSpan value.
Protected method FindFirst(Double, FindType)
This method seraches for the first cell with specified double value.
Protected method FindFirst(String, FindType)
This method seraches for the first cell with specified string value.
Protected method FindParent(Type)
Method used to find parent within a specific type.
(Inherited from CollectionExtended T .)
Protected method FindParent(Type, Boolean)
Method used to find parent within a specific type.
(Inherited from CollectionExtended T .)
Public method FreezePanes
Freezes pane at the current range.
Protected method GetColumnRows
Retrieves an array of CellRange objects representing either columns or rows based on the provided flag.
Public method GetEnumerator
Returns an enumerator that iterates through the collection.
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetNewRangeLocation
Gets new address of range.
Public method GetRectangles
Returns array that contains information about range.
Public method GetRectanglesCount
Returns number of rectangles returned by GetRectangles method.
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Public method IndexOf
Returns the zero-based index of the first occurrence of a specified item within the collection.
(Inherited from CollectionBase T .)
Public method Insert
Inserts an element into the list at the specified index.
(Inherited from CollectionBase T .)
Public method Intersect
Returns intersection of this range with the specified one.
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method Merge
Creates a merged cell from the specified Range object.
Public method Merge(Boolean)
Creates a merged cell from the specified Range object.
Public method Merge(IXLSRange)
Returns merge of this range with the specified one.
Protected method MoveTo
Moves the current object to the specified destination range.
Protected method OnClear
OnClear is invoked before Clear behavior.
(Inherited from CollectionExtended T .)
Protected method OnClearComplete
OnClear is invoked after Clear behavior.
(Inherited from CollectionExtended T .)
Protected method OnInsert
Performs additional processes before inserting a new element into the collection.
(Inherited from CollectionExtended T .)
Protected method OnInsertComplete
Performs additional processes after inserting a new element into the collection.
(Inherited from CollectionExtended T .)
Protected method OnRemove
Performs additional processes before removing an element from the collection.
(Inherited from CollectionExtended T .)
Protected method OnRemoveComplete
Performs additional processes after removing an element from the collection.
(Inherited from CollectionExtended T .)
Protected method OnSet
Performs additional processes before setting a value in the collection.
(Inherited from CollectionExtended T .)
Protected method OnSetComplete
Performs additional processes after setting a value in the collection.
(Inherited from CollectionExtended T .)
Public method Remove
Removes range from the collection.
Public method RemoveAt
Removes the element at the specified index of this instance.
(Inherited from CollectionBase T .)
Protected method SetParent
Sets parent object for class.
(Inherited from CollectionExtended T .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Public method UnMerge
Separates a merged area into individual cells.
Top
See Also