XlCellRange.Parse(String) Method

Returns a XlCellRange object by its reference string in the in the A1 reference style.

Namespace: DevExpress.Export.Xl

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public static XlCellRange Parse(
    string reference
)

VB.NET

Public Shared Function Parse(
    reference As String
) As XlCellRange

Parameters

Name	Type	Description
reference	String	A string that specifies the cell range reference in the A1 reference style.

Returns

Type	Description
XlCellRange	A XlCellRange object created for the specified reference.

Remarks

If the specified string cannot be parsed, a ArgumentException is thrown.

Tip

To get a cell range by the indexes of the bounding rows and columns, use the XlCellRange.FromLTRB method.

Example

Note

A complete sample project is available at https://github.com/DevExpress-Examples/excel-export-api-examples

SparklineActions.cs

// Create a group of line sparklines.                    
XlSparklineGroup group = new XlSparklineGroup(XlCellRange.Parse("B2:E7"), XlCellRange.Parse("F2:F7"));
// Specify the date range for the sparkline group. 
group.DateRange = XlCellRange.Parse("B1:E1");
// Set the sparkline weight.
group.LineWeight = 1.25;
// Display data markers on the sparklines.
group.DisplayMarkers = true;
sheet.SparklineGroups.Add(group);

SparklineActions.vb

' Create a group of line sparklines.                    
Dim group As New XlSparklineGroup(XlCellRange.Parse("B2:E7"), XlCellRange.Parse("F2:F7"))
' Specify the date range for the sparkline group. 
group.DateRange = XlCellRange.Parse("B1:E1")
' Set the sparkline weight.
group.LineWeight = 1.25
' Display data markers on the sparklines.
group.DisplayMarkers = True
sheet.SparklineGroups.Add(group)