XlCellRange.TopLeft Property

Gets or sets the position which specifies the top left cell in the range.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public XlCellPosition TopLeft { get; set; }

VB.NET

Public Property TopLeft As XlCellPosition

Property Value

Type	Description
XlCellPosition	An XlCellPosition structure which defines a cell.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the TopLeft property.

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#

winforms-grid-copy-cells-in-biff8-format-using-excel-export-api/CS/gridCopyToClipboardExample/CopyToClipboardHelper.cs#L157

MemoryStream CreateLinkDataStream() {
    string link = string.Format("Excel\0[Book1]{0}\0{1}:{2}\0\0", sheetName, GetR1C1(this.dataRange.TopLeft), GetR1C1(this.dataRange.BottomRight));
    byte[] linkData = DXEncoding.Default.GetBytes(link);

VB.NET

winforms-grid-copy-cells-in-biff8-format-using-excel-export-api/VB/gridCopyToClipboardExample/CopyToClipboardHelper.vb#L148

Private Function CreateLinkDataStream() As MemoryStream
    Dim link As String = String.Format("Excel" & Microsoft.VisualBasic.Constants.vbNullChar & "[Book1]{0}" & Microsoft.VisualBasic.Constants.vbNullChar & "{1}:{2}" & Microsoft.VisualBasic.Constants.vbNullChar & Microsoft.VisualBasic.Constants.vbNullChar, sheetName, GetR1C1(dataRange.TopLeft), GetR1C1(dataRange.BottomRight))
    Dim linkData As Byte() = DXEncoding.Default.GetBytes(link)