TryExtractDataRange Method

In This Topic

Extract data range of sparkline group.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function TryExtractDataRange( _
   ByVal worksheet As Worksheet, _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal expression As Expression, _
   ByRef dataRange As WorksheetReference, _
   ByRef dataNamedRange As DefinedName _
) As Boolean

'Usage
 
Dim worksheet As Worksheet
Dim row As Integer
Dim column As Integer
Dim expression As Expression
Dim dataRange As WorksheetReference
Dim dataNamedRange As DefinedName
Dim value As Boolean
 
value = SparklineGroup.TryExtractDataRange(worksheet, row, column, expression, dataRange, dataNamedRange)

public static bool TryExtractDataRange( 
   Worksheet worksheet,
   int row,
   int column,
   Expression expression,
   out WorksheetReference dataRange,
   out DefinedName dataNamedRange
)

Parameters

worksheet: The worksheet.
row: An integer value indicates the row index.
column: An integer value indicates the column index.
expression: The expression.
dataRange: The data range.
dataNamedRange: The data named range.

Return Value

true if the specified expression represents data range of sparkline group; otherwise, false.

Reference

SparklineGroup Class
SparklineGroup Members