RangeExtensions Members
Defines extension methods for the CellRange interface.Methods
| Name | Description |
|---|---|
| AutoFitColumns(CellRange) static | Adjusts the width of columns that comprise the cell range to accommodate the cell content of this range. |
| AutoFitRows(CellRange) static | Adjusts the height of rows that comprise the cell range to accommodate the cell content of this range. |
| Average(CellRange, Boolean, Boolean) static | Returns the average of numerical values in the current cell range. |
| Clear(CellRange) static | Removes cell content, formatting, hyperlinks and comments. |
| ClearComments(CellRange) static | Removes cell comments. |
| ClearContents(CellRange) static | Removes cell content. |
| ClearFormats(CellRange) static | Removes cell formatting. |
| ClearHyperlinks(CellRange) static | Removes cell hyperlinks. |
| ClearOutline(CellRange, Boolean, Boolean) static | Clears the outline for the specified range of cells. |
| Count(CellRange, Boolean, Boolean) static | Returns the number of cells in the current cell range that contain data. |
| Delete(CellRange, DeleteMode) static | Deletes the cell range from the worksheet. |
| Delete(CellRange) static | Deletes the cell range from the worksheet, shifting other cells in the same row to the left. |
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| GroupColumns(CellRange, Boolean) static | Groups columns that comprise the cell range. |
| GroupRows(CellRange, Boolean) static | Groups rows that comprise the cell range. |
| Insert(CellRange, InsertCellsMode) static | Inserts the cell range in the worksheet. |
| Insert(CellRange) static | Inserts the cell range in the worksheet, shifting other cells in the same column down. |
| Max(CellRange, Boolean, Boolean) static | Returns the maximum numerical value in the current cell range. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| Merge(CellRange, MergeCellsMode) static | Merge cells in the specified mode. |
| Merge(CellRange) static | Merges cells. |
| Min(CellRange, Boolean, Boolean) static | Returns the minimum numerical value in the current cell range. |
| NumericalCount(CellRange, Boolean, Boolean) static | Returns the number of cells in the current cell range that contain numerical data. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| RemoveSubtotal(CellRange) static | Removes subtotals for the specified cell range. |
| Select(CellRange, Boolean) static | Selects the cell range and specifies whether to expand cell selection to include merged cells. |
| Select(CellRange) static | Selects the cell range. |
| Subtotal(CellRange, Int32, List<Int32>, Int32, String) static | Creates subtotals for the specified range of cells. |
| Sum(CellRange, Boolean, Boolean) static | Returns the sum of numerical values in the current cell range. |
| ToString() | Returns a string that represents the current object. Inherited from Object. |
| UnGroupColumns(CellRange, Boolean) static | Ungroups the grouped columns that comprise the cell range. |
| UnGroupRows(CellRange, Boolean) static | Ungroups the grouped rows that comprise the cell range. |
| UnMerge(CellRange) static | Unmerges cells that have been merged. |
See Also