XlCellPosition(Int32, Int32, XlPositionType, XlPositionType) Constructor

Initializes a new instance of the XlCellPosition class with the specified column and row indexes and reference type.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v19.2.Core.dll

Declaration

C#

public XlCellPosition(
    int column,
    int row,
    XlPositionType columnType,
    XlPositionType rowType
)

VB.NET

Public Sub New(
    column As Integer,
    row As Integer,
    columnType As XlPositionType,
    rowType As XlPositionType
)

Parameters

Name	Type	Description
column	Int32	An integer that is the zero-based column index.
row	Int32	An integer that is the zero-based row index.
columnType	XlPositionType	A XlPositionType enumeration member that specifies the column reference type.
rowType	XlPositionType	A XlPositionType enumeration member that specifies the row reference type.

Remarks

If the column index is -1 and the row index is positive, the position denotes the entire row. If the row index is -1 and the column index is positive, the position denotes the entire column. If any index is a negative integer other than -1, it is substituted with -1.

The following table illustrates how the textual cell reference relates to the XlCellPosition class instance.

Cell Reference	XlCellPosition constructor
C3	XlCellPosition(2,2)
$C$3	XlCellPosition(2,2,XlPositionType.Absolute, XlPositionType.Absolute)