RangesCollection Methods

Activages a single cell, scroll to it and activates the respective sheet To select a range of cells, use the Select method.

Adds a range to the collection.

Adds new range to the collection.

Adds a comment to the range.

Adds a range to the collection.

Adds range to the collection.

Autofits all columns.

Autofits all rows.

Sets around border for current range.

Sets around border for current range.

Sets around border for current range.

Sets around border for current range.

Sets inside border for current range.

Sets inside border for current range.

Sets inside border for current range.

Sets inside border for current range.

Sets none border for current range.

Removes all objects from the System.Collections.CollectionBase instance.

Clears conditional formats.

Creates copy of the collection.

Clones current IXLSRange.

Collapses current group.

Determines whether the collection contains a specific item.

Copies the range to the specified range.

Copies the range to the specified range.

Copies the range to the specified range.

Copies the elements of the collection to an array, starting at a particular array index.

Enlarges internal storage if necessary.

Determines whether the specified object is equal to the current object.

Expands current group.

Expands current group.

Exports data to a DataTable based on the provided ExportTableOptions.

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.

This method seraches for the all cells with specified bool value.

This method seraches for the all cells with specified DateTime value.

This method seraches for the all cells with specified TimeSpan value.

This method seraches for the all cells with specified double value.

This method seraches for the all cells with specified string value.

Finds the cell with the input bool.

Finds the cell with the input datetime.

Finds the cell with the input double.

Finds the cell with the input string.

Finds the cell with input timespan

Finds the cell with the input bool.

Finds the cell with the input datetime.

This method seraches for the first cell with specified bool value.

This method seraches for the first cell with specified DateTime value.

This method seraches for the first cell with specified TimeSpan value.

This method seraches for the first cell with specified double value.

This method seraches for the first cell with specified string value.

Finds the cell with the input double.

Method used to find parent within a specific type.

Method used to find parent within a specific type.

Finds the cell with the input string.

Finds the cell with the input time span.

Freezes pane at the current range.

Retrieves an array of CellRange objects representing either columns or rows based on the provided flag.

Returns an enumerator that iterates through the collection.

Serves as the default hash function.

Gets new address of range.

Returns array that contains information about range.

Returns number of rectangles returned by GetRectangles method.

Gets the Type of the current instance.

Returns the zero-based index of the first occurrence of a specified item within the collection.

Inserts an element into the list at the specified index.

Get intersection range with the specified range.

Returns intersection of this range with the specified one.

Creates a shallow copy of the current Object .

Creates a merged cell from the specified Range object.

Creates a merged cell from the specified Range object.

Returns merge of this range with the specified one.

Moves the cells to the specified Range.

Moves the cells to the specified Range.

Moves the current object to the specified destination range.

OnClear is invoked before Clear behavior.

OnClear is invoked after Clear behavior.

Performs additional processes before inserting a new element into the collection.

Performs additional processes after inserting a new element into the collection.

Performs additional processes before removing an element from the collection.

Performs additional processes after removing an element from the collection.

Performs additional processes before setting a value in the collection.

Performs additional processes after setting a value in the collection.

Removes range from the collection.

Removes range from the collection.

Removes the element at the specified index of this instance.

Sets parent object for class.

Returns a string that represents the current object.

Separates a merged area into individual cells.