Skip to main content

XlCellRange Members

Defines a range of cells.

Constructors

Name	Description
XlCellRange(XlCellPosition, XlCellPosition)	Initializes a new instance of the XlCellRange class with the specified top left and bottom right positions.
XlCellRange(XlCellPosition)	Initializes a new instance of the XlCellRange class which defines a single cell.
XlCellRange(String, XlCellPosition, XlCellPosition)	Initializes a new instance of the XlCellRange class with the specified worksheet, top left and bottom right positions.

Properties

Name	Description
BottomRight	Gets or sets the position which specifies the bottom right cell in the range.
SheetName	Gets or sets the name of the worksheet that owns the range.
TopLeft	Gets or sets the position which specifies the top left cell in the range.

Name	Description
AsAbsolute()	Returns a new XlCellRange instance transformed into absolute reference.
AsRelative()	Returns a new XlCellRange instance transformed into relative reference.
ColumnInterval(Int32, Int32, XlPositionType) static	Returns a range that is a continuous interval of entire columns referenced using the specified reference type.
ColumnInterval(Int32, Int32) static	Returns a range that is a continuous interval of entire columns.
Equals(Object, Object) static	Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object)	Determines whether the specified object is equal to the current XlCellRange instance.
FromLTRB(Int32, Int32, Int32, Int32) static	Returns a XlCellRange object by the indexes of the bounding rows and columns.
GetHashCode()	Gets a numerical value that is used to identify an object during equality testing.
GetType()	Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected	Creates a shallow copy of the current Object. Inherited from Object.
Parse(String) static	Returns a XlCellRange object by its reference string in the in the A1 reference style.
ReferenceEquals(Object, Object) static	Determines whether the specified Object instances are the same instance. Inherited from Object.
RowInterval(Int32, Int32, XlPositionType) static	Returns a range that is a continuous interval of entire rows referenced using the specified reference type.
RowInterval(Int32, Int32) static	Returns a range that is a continuous interval of entire rows referenced using the specified reference type.
ToString()	Get a string reference to the range defined by the XlCellRange object.
ToString(Boolean)	Get a string reference to the range defined by the XlCellRange object.
ToString(CultureInfo)	Get a string reference to the range defined by the XlCellRange object.

See Also

XlCellRange Class

DevExpress.Export.Xl Namespace

Was this page helpful?

Thanks for your feedback!

How can we improve this help topic?

Add an example/code snippet.

Improve topic clarity.

Improve organization/make it easier to find.

Include additional information/content.

Additional comments/thoughts:

If you have any questions, submit a ticket to our Support Center.

No

Your feedback is appreciated.