XlCellRange.ToString(Boolean) Method

Get a string reference to the range defined by the XlCellRange object.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public string ToString(
    bool intervalRange
)

VB.NET

Public Function ToString(
    intervalRange As Boolean
) As String

Parameters

Name	Type	Description
intervalRange	Boolean	True, to get single cell reference displayed as an interval; otherwise, false.

Returns

Type	Description
String	A string that is the reference to the worksheet range in A1 style. If a worksheet name is present (the XlCellRange.SheetName is not null), it is included in the reference.

Remarks

A string reference to a cell range is composed of two cell references (top left and bottom right cells) delimited with a semicolon (“A2:B4”). For a range consisting of a single cell, the second cell reference is the same so it is omitted by default (‘C1”). However, you can set the parameter of the method to true to get a string that looks like a range reference (“C1:C1”).