XlCellPosition Struct

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

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public struct XlCellPosition

VB.NET

Public Structure XlCellPosition

Related API Members

The following members accept/return XlCellPosition objects:

• IXlCell.Position
• IXlSheet.SplitPosition
• XlCellPosition.AsAbsolute()
• XlCellPosition.AsRelative()
• XlCellPosition.InvalidValue
• XlCellPosition.TopLeft
• XlCellRange.BottomRight
• XlCellRange.TopLeft

Remarks

The XlCellPosition instance is accessible with the IXlCell.Position property of a single cell or the XlCellRange.TopLeft and XlCellRange.BottomRight properties of a worksheet range.

The XlCellPosition class is used to specify coordinates of a single cell or a worksheet range. It is used as a parameter in the IXlCell.SetSharedFormula, IXlPicture.FitToCell and IXlPicture.StretchToCell methods.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlCellPosition struct.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/PageViewAndLayoutActions.cs#L37

// Freeze the first row in the worksheet.
sheet.SplitPosition = new XlCellPosition(0, 1);
#endregion #FreezeRow

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/CS/GridDataAwareExportCustomization/Form1.cs#L63

if(e.DataSourceRowIndex < 0) {
    e.ExportContext.MergeCells(new XlCellRange(new XlCellPosition(0, e.DocumentRow - 1), new XlCellPosition(5, e.DocumentRow - 1)));
}

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/CS/gridCopyToClipboardExample/CopyToClipboardHelper.cs#L162

string GetR1C1(XlCellPosition cellPosition) {
    return string.Format("R{0}C{1}", cellPosition.Row + 1, cellPosition.Column + 1);

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/PageViewAndLayoutActions.vb#L40

                    ' Freeze the first row in the worksheet.
                    sheet.SplitPosition = New XlCellPosition(0, 1)
'                    #End Region ' #FreezeRow

how-to-customize-the-gridcontrols-data-aware-export-output-t247610/VB/GridDataAwareExportCustomization/Form1.vb#L66

If e.DataSourceRowIndex < 0 Then
    e.ExportContext.MergeCells(New XlCellRange(New XlCellPosition(0, e.DocumentRow - 1), New XlCellPosition(5, e.DocumentRow - 1)))
End If

how-to-copy-cell-data-in-an-excel-format-biff8-to-the-clipboard-using-xl-export-library-t266171/VB/gridCopyToClipboardExample/CopyToClipboardHelper.vb#L165

Private Function GetR1C1(ByVal cellPosition As XlCellPosition) As String
    Return String.Format("R{0}C{1}", cellPosition.Row + 1, cellPosition.Column + 1)