Range Methods

The Range type exposes the following members.

Methods
  NameDescription
Public methodApplyStyle
Applies formats for a whole range.
Public methodCopy(Range)
Copies data (including formulas), formatting, drawing objects etc. from a source range.
Public methodCopy(Range, PasteOptions)
Copying the range with paste special options.
Public methodCopyData
Copies cell data (including formulas) from a source range.
Public methodCopyStyle
Copies style settings from a source range.
Public methodCopyValue
Copies cell value from a source range.
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public methodExportDataTable
Exports data in this range to a DataTable object.
Public methodExportDataTable(ExportTableOptions)
Exports data in this range to a DataTable object.
Public methodExportDataTableAsString
Exports data in this range to a DataTable object.
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetCellOrNull
Gets Cell object or null in this range.
Public methodGetEnumerator
Gets the enumerator for cells in this Range.
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetOffset
Gets Range range by offset.
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Public methodIntersect
Returns a Range object that represents the rectangular intersection of two ranges.
Public methodIsIntersect
Indicates whether the range is intersect.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodMerge
Combines a range of cells into a single cell.
Public methodMoveTo
Move the current range to the dest range.
Public methodPutValue
Puts a value into the range, if appropriate the value will be converted to other data type and cell's number format will be reset.
Public methodSetOutlineBorder
Sets outline border around a range of cells.
Public methodSetOutlineBorders(CellBorderType, Color)
Sets the outline borders around a range of cells with same border style and color.
Public methodSetOutlineBorders(CellBorderType, Color)
Sets out line borders around a range of cells.
Public methodSetStyle
Sets the style of the range.
Public methodToString
Returns a string represents the current Range object.
Public methodUnion
Returns the union of two ranges.
Public methodUnMerge
Unmerges merged cells of this range.
See Also