The ExcelRangeBase type exposes the following members.
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
|
