ExcelRange Members

Office Open XML

The ExcelRange type exposes the following members.

Methods

  NameDescription
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.)
AutoFitColumnsOverloaded.
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
Determines whether the specified Object is equal to the current Object.
(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.)
LoadFromCollectionOverloaded.
LoadFromDataTableOverloaded.
LoadFromTextOverloaded.
MoveNext (Inherited from ExcelRangeBase.)
OffsetOverloaded.
Reset (Inherited from ExcelRangeBase.)
ToString (Inherited from ExcelAddressBase.)

Properties

  NameDescription
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.)
ItemOverloaded.
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.)

See Also