Skip to main content
A newer version of this page is available. .

XlCellPosition Members

Defines the column, row and the reference type (relative or absolute).

Constructors

Name Description
XlCellPosition(Int32, Int32, XlPositionType, XlPositionType) Initializes a new instance of the XlCellPosition class with the specified column and row indexes and reference type.
XlCellPosition(Int32, Int32) Initializes a new instance of the XlCellPosition class with the specified column and row indexes.

Properties

Name Description
Column Gets the index of a column in the position.
ColumnType Gets the reference type of the column in the position.
InvalidValue static A static method to get a special XlCellPosition instance that denotes an invalid position.
IsAbsolute Gets whether both the column and the row are absolute references.
IsColumn Gets whether the position refers to the entire column.
IsColumnOrRow Gets whether the position refers to the entire column or the entire row.
IsRelative Gets whether both the column and the row are relative references.
IsRow Gets whether the position refers to the entire row.
IsValid Gets whether the XlCellPosition instance denotes a valid position.
MaxColumnCount static Gets the maximum number of columns.
MaxRowCount static Gets the maximum number of rows.
Row Gets the index of a row in the position.
RowType Gets the reference type of the row in the position.
TopLeft static Returns the top left position in a worksheet which is the point of reference for cell coordinates.

Methods

Name Description
AsAbsolute() Returns a new XlCellPosition instance transformed into absolute reference.
AsRelative() Returns a new XlCellPosition instance transformed into relative reference.
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 XlCellPosition instance.
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.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Constructs a textual cell reference from the position.
See Also