ExcelRangeBase Properties

Office Open XML

The ExcelRangeBase type exposes the following members.

Properties

  NameDescription
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

See Also