RangeExtensions Methods
Defines extension methods for the Range interface.Name | Description |
---|---|
AutoFitColumns(Range) static | Adjusts the width of columns that comprise the cell range to accommodate the cell content of this range. |
AutoFitRows(Range) static | Adjusts the height of rows that comprise the cell range to accommodate the cell content of this range. |
Clear(Range) static | Removes cell content, formatting, hyperlinks and comments. |
ClearComments(Range) static | Removes cell comments. |
ClearContents(Range) static | Removes cell content. |
ClearFormats(Range) static | Removes cell formatting. |
ClearHyperlinks(Range) static | Removes cell hyperlinks. |
ClearOutline(Range, Boolean, Boolean) static | Clears the outline for the specified range of cells. |
Delete(Range, DeleteMode) static | Deletes the cell range from the worksheet. |
Delete(Range) 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(Range, Boolean) static | Groups columns that comprise the cell range. |
GroupRows(Range, Boolean) static | Groups rows that comprise the cell range. |
Insert(Range, InsertCellsMode) static | Inserts the cell range in the worksheet. |
Insert(Range) static | Inserts the cell range in the worksheet, shifting other cells in the same column down. |
MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
Merge(Range, MergeCellsMode) static | Merge cells in the specified mode. |
Merge(Range) static | Merges cells. |
ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
RemoveSubtotal(Range) static | Removes subtotals for the specified cell range. |
Select(Range) static | Selects the cell range. |
Subtotal(Range, Int32, List<Int32>, Int32, String) static | Creates subtotals for the specified range of cells. |
ToString() | Returns a string that represents the current object. Inherited from Object. |
UnGroupColumns(Range, Boolean) static | Ungroups the grouped columns that comprise the cell range. |
UnGroupRows(Range, Boolean) static | Ungroups the grouped rows that comprise the cell range. |
UnMerge(Range) static | Unmerges cells that have been merged. |
See Also