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.) |
Properties
| Name | Description | |
|---|---|---|
 | Address |
The address for the range
(Inherited from ExcelAddress.) |
| AutoFilter |
Set an autofilter for the range
(Inherited from ExcelRangeBase.) |
| Comment |
returns the comment object of the first cell in the range
(Inherited from ExcelRangeBase.) |
| Current |
The current range when enumerating
(Inherited from ExcelRangeBase.) |
| DataValidation |
Data validation for this range.
(Inherited from ExcelRangeBase.) |
| End |
Gets the row and column of the bottom right cell.
(Inherited from ExcelAddressBase.) |
| Formula |
Gets or sets a formula for a range.
(Inherited from ExcelRangeBase.) |
| FormulaR1C1 |
Gets or Set a formula in R1C1 format.
(Inherited from ExcelRangeBase.) |
| FullAddress |
Address including sheetname
(Inherited from ExcelRangeBase.) |
| FullAddressAbsolute |
Address including sheetname
(Inherited from ExcelRangeBase.) |
| Hyperlink |
Set the hyperlink property for a range of cells
(Inherited from ExcelRangeBase.) |
| IsArrayFormula |
Is the range a part of an Arrayformula
(Inherited from ExcelRangeBase.) |
| IsName |
If the address is a defined name
(Inherited from ExcelAddressBase.) |
| IsRichText |
If the value is in richtext format.
(Inherited from ExcelRangeBase.) |
| Item | Overloaded. |
| Merge |
If the cells in the range are merged.
(Inherited from ExcelRangeBase.) |
| RichText |
Cell value is richtext formated.
(Inherited from ExcelRangeBase.) |
| Start |
Gets the row and column of the top left cell.
(Inherited from ExcelAddressBase.) |
| Style |
The styleobject for the range.
(Inherited from ExcelRangeBase.) |
| StyleID |
The style ID.
It is not recomended to use this one. Use Named styles as an alternative.
If you do, make sure that you use the Style.UpdateXml() method to update any new styles added to the workbook.
(Inherited from ExcelRangeBase.) |
| StyleName |
The named style
(Inherited from ExcelRangeBase.) |
| Text |
Returns the formated value.
(Inherited from ExcelRangeBase.) |
| Value |
Set the range to a specific value
(Inherited from ExcelRangeBase.) |
| Worksheet |
WorkSheet object
(Inherited from ExcelRangeBase.) |
