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.v20.2.Core.dll
NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core
Declaration
public XlCellPosition(
int column,
int row,
XlPositionType columnType,
XlPositionType rowType
)
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) |