RangeExtensions Methods
Defines extension methods for the CellRange interface.
Name | Description |
---|---|
Auto |
Adjusts the width of columns that comprise the cell range to accommodate the cell content of this range. |
Auto |
Adjusts the height of rows that comprise the cell range to accommodate the cell content of this range. |
Average |
Returns the average of numerical values in the current cell range. |
Clear |
Removes cell content, formatting, hyperlinks and comments. |
Clear |
Removes cell comments. |
Clear |
Removes cell content. |
Clear |
Removes cell formatting. |
Clear |
Removes cell hyperlinks. |
Clear |
Clears the outline for the specified range of cells. |
Count |
Returns the number of cells in the current cell range that contain data. |
Delete |
Deletes the cell range from the worksheet. |
Delete |
Deletes the cell range from the worksheet, shifting other cells in the same row to the left. |
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Group |
Groups columns that comprise the cell range. |
Group |
Groups rows that comprise the cell range. |
Insert |
Inserts the cell range in the worksheet. |
Insert |
Inserts the cell range in the worksheet, shifting other cells in the same column down. |
Max |
Returns the maximum numerical value in the current cell range. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Merge |
Merge cells in the specified mode. |
Merge |
Merges cells. |
Min |
Returns the minimum numerical value in the current cell range. |
Numerical |
Returns the number of cells in the current cell range that contain numerical data. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
Remove |
Removes subtotals for the specified cell range. |
Select |
Selects the cell range and specifies whether to expand cell selection to include merged cells. |
Select |
Selects the cell range. |
Subtotal |
Creates subtotals for the specified range of cells. |
Sum |
Returns the sum of numerical values in the current cell range. |
To |
Returns a string that represents the current object. Inherited from Object. |
Un |
Ungroups the grouped columns that comprise the cell range. |
Un |
Ungroups the grouped rows that comprise the cell range. |
Un |
Unmerges cells that have been merged. |
See Also