Spread Silverlight Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / Worksheet Class / GetSparkline Method
The row.
The column.
Example


In This Topic
    GetSparkline Method (Worksheet)
    In This Topic
    Gets the sparkline for the specified cell.
    Syntax
    'Declaration
     
    Public Function GetSparkline( _
       ByVal row As Integer, _
       ByVal column As Integer _
    ) As Sparkline
    'Usage
     
    Dim instance As Worksheet
    Dim row As Integer
    Dim column As Integer
    Dim value As Sparkline
     
    value = instance.GetSparkline(row, column)
    public Sparkline GetSparkline( 
       int row,
       int column
    )

    Parameters

    row
    The row.
    column
    The column.

    Return Value

    The sparkline of the cell.
    Example
    This example uses the GetSparkline method.
    GrapeCity.Windows.SpreadSheet.Data.CellRange cellr = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5);
    GrapeCity.Windows.SpreadSheet.Data.SparklineSetting ex = new GrapeCity.Windows.SpreadSheet.Data.SparklineSetting();
    ex.SeriesColor  = System.Windows.Media.Colors.Aquamarine; 
    gcSpreadSheet1.Sheets[0].Cells[0, 0].Value = 2;
    gcSpreadSheet1.Sheets[0].Cells[0, 1].Value = 5;
    gcSpreadSheet1.Sheets[0].Cells[0, 2].Value = 4;
    gcSpreadSheet1.Sheets[0].Cells[0, 3].Value = -1;
    gcSpreadSheet1.Sheets[0].Cells[0, 4].Value = 3;
    gcSpreadSheet1.Sheets[0].SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, ex);
    gcSpreadSheet1.Invalidate();           
    
            private void button1_Click(object sender, RoutedEventArgs e)
            {
                listBox1.Items.Add(gcSpreadSheet1.Sheets[0].GetSparkline(0, 5).ToString());
                gcSpreadSheet1.Sheets[0].RemoveSparkline(0, 5);
                gcSpreadSheet1.Invalidate();
            }
    Dim cellr As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 1, 5)
    Dim ex As New GrapeCity.Windows.SpreadSheet.Data.SparklineSetting()
    ex.SeriesColor = System.Windows.Media.Colors.Aquamarine
    GcSpreadSheet1.Sheets(0).Cells(0, 0).Value = 2
    GcSpreadSheet1.Sheets(0).Cells(0, 1).Value = 5
    GcSpreadSheet1.Sheets(0).Cells(0, 2).Value = 4
    GcSpreadSheet1.Sheets(0).Cells(0, 3).Value = -1
    GcSpreadSheet1.Sheets(0).Cells(0, 4).Value = 3
    GcSpreadSheet1.Sheets(0).SetSparkline(0, 5, cellr, GrapeCity.Windows.SpreadSheet.Data.DataOrientation.Horizontal, GrapeCity.Windows.SpreadSheet.Data.SparklineType.Column, ex)
    GcSpreadSheet1.Invalidate()
    
        Private Sub Button1_Click(sender As System.Object, e As System.Windows.RoutedEventArgs) Handles Button1.Click
            ListBox1.Items.Add(GcSpreadSheet1.Sheets(0).GetSparkline(0, 5).ToString())
            GcSpreadSheet1.Sheets(0).RemoveSparkline(0, 5)
            GcSpreadSheet1.Invalidate()
        End Sub
    See Also