ExcelRange Methods
From Office Open XML
The ExcelRange type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
| AddComment |
Adds a new comment for the range.
If this range contains more than one cell, the top left comment is returned by the method.
(Inherited from ExcelRangeBase.) | |
| AutoFitColumns | Overloaded. | |
| Clear |
Clear all cells
(Inherited from ExcelRangeBase.) | |
| Copy |
Copies the range of cells to an other range
(Inherited from ExcelRangeBase.) | |
| CreateArrayFormula |
Creates an array-formula.
(Inherited from ExcelRangeBase.) | |
| Dispose | (Inherited from ExcelRangeBase.) | |
| Equals | (Inherited from Object.) | |
| GetEnumerator | (Inherited from ExcelRangeBase.) | |
| GetHashCode |
Serves as a hash function for a particular type.
(Inherited from Object.) | |
| GetType |
Gets the Type of the current instance.
(Inherited from Object.) | |
| GetValue<(Of <(T>)>) |
Get the strongly typed value of the cell.
(Inherited from ExcelRangeBase.) | |
| LoadFromArrays |
Loads data from the collection of arrays of objects into the range, starting from
the top-left cell.
(Inherited from ExcelRangeBase.) | |
| LoadFromCollection | Overloaded. | |
| LoadFromDataTable | Overloaded. | |
| LoadFromText | Overloaded. | |
| MoveNext | (Inherited from ExcelRangeBase.) | |
| Offset | Overloaded. | |
| Reset | (Inherited from ExcelRangeBase.) | |
| ToString | (Inherited from ExcelAddressBase.) |