Range Class
Encapsulates the object that represents a range of cells within a spreadsheet.
Inheritance Hierarchy
SystemObject
  Aspose.CellsRange

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.4.0.0 (19.4)
Syntax
public class Range

The Range type exposes the following members.

Properties
  NameDescription
Public propertyAddress
Gets address of the range.
Public propertyCellCount
Gets all cell count in the range.
Public propertyColumnCount
Gets the count of columns in the range.
Public propertyColumnWidth
Sets or gets the column width of this range
Public propertyEntireColumn
Gets a Range object that represents the entire column (or columns) that contains the specified range.
Public propertyEntireRow
Gets a Range object that represents the entire row (or rows) that contains the specified range.
Public propertyFirstColumn
Gets the index of the first column of the range.
Public propertyFirstRow
Gets the index of the first row of the range.
Public propertyHyperlinks
Gets all hyperlink in the range.
Public propertyItem
Gets Cell object in this range.
Public propertyName
Gets or sets the name of the range.
Public propertyRefersTo
Gets the range's refers to.
Public propertyRowCount
Gets the count of rows in the range.
Public propertyRowHeight
Sets or gets the height of rows in this range
Public propertyValue
Gets and sets the value of the range.
Public propertyWorksheet
Gets the Worksheetobject which contains this range.
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