The ExcelRangeBase 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.
|
| AutoFitColumns | Overloaded. |
| Clear |
Clear all cells
|
| Copy |
Copies the range of cells to an other range
|
| CreateArrayFormula |
Creates an array-formula.
|
| Dispose | Releases all resources used by the ExcelRangeBase |
| Equals | (Inherited from Object.) |
| GetEnumerator | |
| 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.
|
| LoadFromArrays |
Loads data from the collection of arrays of objects into the range, starting from
the top-left cell.
|
| LoadFromCollection | Overloaded. |
| LoadFromDataTable | Overloaded. |
| LoadFromText | Overloaded. |
| MoveNext | |
| Offset | Overloaded. |
| Reset | |
| ToString | (Inherited from ExcelAddressBase.) |
Properties
| Name | Description | |
|---|---|---|
 | Address |
The address for the range
(Inherited from ExcelAddress.) |
| AutoFilter |
Set an autofilter for the range
|
| Comment |
returns the comment object of the first cell in the range
|
| Current |
The current range when enumerating
|
| DataValidation |
Data validation for this range.
|
| End |
Gets the row and column of the bottom right cell.
(Inherited from ExcelAddressBase.) |
| Formula |
Gets or sets a formula for a range.
|
| FormulaR1C1 |
Gets or Set a formula in R1C1 format.
|
| FullAddress |
Address including sheetname
|
| FullAddressAbsolute |
Address including sheetname
|
| Hyperlink |
Set the hyperlink property for a range of cells
|
| IsArrayFormula |
Is the range a part of an Arrayformula
|
| IsName |
If the address is a defined name
(Inherited from ExcelAddressBase.) |
| IsRichText |
If the value is in richtext format.
|
| Merge |
If the cells in the range are merged.
|
| RichText |
Cell value is richtext formated.
|
| Start |
Gets the row and column of the top left cell.
(Inherited from ExcelAddressBase.) |
| Style |
The styleobject for the range.
|
| 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.
|
| StyleName |
The named style
|
| Text |
Returns the formated value.
|
| Value |
Set the range to a specific value
|
| Worksheet |
WorkSheet object
|
