Skip to main content
Row

RangeExtensions Methods

Defines extension methods for the CellRange interface.
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