Identifies a range of cells in a Worksheet.
The following tables list the members exposed by the CellRange type.
Name | Description | |
---|---|---|
Gets the bottom side of the range. |
||
Gets a list with format objects that can be used to customize the appearance of the cells in the range based on various conditions. |
||
Gets the left side of the range. |
||
Gets the right side of the range. |
||
Gets an IStyle object that can be used to customize the appearance of all cells in the range. |
||
Gets the top side of the range. |
||
Gets an IValidation object that can be used to specify validation rules for the data in the cell range. |
Name | Description | |
---|---|---|
Automatically fills the values of the cells in the specified range based on the values of the cells in this range. |
||
Overloaded. Enables or toggles autofiltering. |
||
Clears the content of the cells in this range. |
||
Fills the data in this range according to the current data and the specified options. |
||
Returns an enumerator object that can be used to iterate through the cells in the range. |
||
Inserts new cells in the current range of cells. The existing cells are pushed down or right based on the value of direction. |
||
Merges the cells in this range into a single cell. |
||
Overloaded. Moves the data from the current range to another location. |
||
Remove the cells in the current range of cells. |
||
Clears the contents of the cells in the range, as well as their associated styles, hyperlinks, annotations, conditional formatting and data validations. |
||
Sorts the data in this range according to the specified options. |
||
Object.ToString override. |
||
Unmerges all merged cells intersecting with this range. |