.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
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.

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) static

Deletes the cell range from the worksheet, shifting other cells in the same row to the left.

Delete(CellRange, DeleteMode) static

Deletes the cell range from the worksheet.

Equals(Object) Determines whether the specified object is equal to the current object.
(Inherited from Object)
Equals(Object, Object) static Determines whether the specified object instances are considered equal.
(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) static

Inserts the cell range in the worksheet, shifting other cells in the same column down.

Insert(CellRange, InsertCellsMode) static

Inserts the cell range in the worksheet.

Max(CellRange, Boolean, Boolean) static

Returns the maximum numerical value in the current cell range.

MemberwiseClone() Creates a shallow copy of the current Object.
(Inherited from Object)
Merge(CellRange) static

Merges cells.

Merge(CellRange, MergeCellsMode) static

Merge cells in the specified mode.

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) 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