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.