ExcelRangeBase Members

Office Open XML

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

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